I am currently working on an MS access database created by a specialist.
The db is split into two accdb files - a forms database and the raw data itself. Recently this broke and I can no longer access the raw data.
I still have access to the forms database and seemingly the ability to add/save new raw data.
I do not know how the linking between the two accdb files works and need to put this right if possible.
Also, I need to move this database to a new computer, but having tried to simply copy/paste this does not work - I had presumed this would be the case as I understand the file is "rooted" to its current location.
I need a quick fix in the first instance, so I can reliably save new details on the db (on my new pc), which I am hoping should be a relatively quick job for someone of your experience.
Many thanks in advance.