I am working for SCDOT on a project and I have created different personal geodatabases for highway crashes for each year, also I have created a separate personal geodatabase for the network (routes). Each crash has a LRS (linear referencing) field that needs to be related to the LRS field in routes network. Apparently, Create Relationship Class does not work to relate two separate geodatabases. Is there any other solution for that?
I would suggest using file geodatabases instead of personal geodatabases. Not that you are using Pro, but that software does not even support personal geodatabases.
what do you mean by the software does not support personal geodatabases? what are the limitations?
He just meant that the Personal Geodatabases (*.mdb) are not supported with ArcGIS Pro.
Types of geodatabases—ArcGIS Pro | ArcGIS for Desktop
001324: Personal Geodatabases are not supported in 64-bit versions of ArcGIS.—Help | ArcGIS Desktop
This does not matter for you, if you are using ArcGIS Desktop as it is a 32-Bit application.
ESRI is moving more and more to Pro as their recommended desktop app (IMHO - not yet a replacement for Desktop though), as that is where they are placing most of their development resources. Pro is a 64-bit app and personal geodatabases are not supported in a 64-bit environment. Just information to plan for the future with your GIS architecture.
Yes, why separate dbs, personal or otherwise?
Why not just one feature class, with a "Year" column? (preferably in a FGDB)
It has to be like that for so many practical and administrative reasons. We use personal geodatabases because they ca be used by Access as well.
Check if "Relates" suits your needs:
Essentials of relating tables—Help | ArcGIS Desktop
Relating the attributes in one table to another—Help | ArcGIS Desktop
Relates defined in ArcMap are essentially the same as simple relationship classes defined in a geodatabase, except that they are saved with the map instead of in a geodatabase.
It works, but it cannot be saved in the database
Yes, that is the limitation I mentioned. You will have to relate required data and save them in the Map Document (MXD).
Other than this, I don't see an option for you.