iamchemist
Programmer
I am running a fairly complex Access 2007 multi-user Database (a .accdb Database)at a non-profit Food Pantry. A while back we split that database into backend and frontend parts. However, the split did not seem to go as expected. We did end up with forms, queries, etc. in the frontend, but the backend appeared to be the entire database and not just tables.
Recently I put the Database back together by deleting linked tables from the frontend, importing all the real tables from the backend to the frontend, and then splitting the frontend Database again. This time the split seemed to go well. We ended up with only Tables in the backend and everything else in the frontend. It also speeded up multi-user Database use about 3X. AND THE DATABASE APPEARS TO RUN NORMALLY.
The problem is that when I go to "Database Tools>Relationships on the backend Database, it shows no relationships. Obviously this can't really be true, or it wouldn't be running.
I wondered if I might remedy this by importing the System Table, MSysRelationships, from another recent backend Database, but I am told that I would need "Modify Design Permission" to even try that. I can find no way to get that permission on a .accdb Database.
I would appreciate any suggestions.
Recently I put the Database back together by deleting linked tables from the frontend, importing all the real tables from the backend to the frontend, and then splitting the frontend Database again. This time the split seemed to go well. We ended up with only Tables in the backend and everything else in the frontend. It also speeded up multi-user Database use about 3X. AND THE DATABASE APPEARS TO RUN NORMALLY.
The problem is that when I go to "Database Tools>Relationships on the backend Database, it shows no relationships. Obviously this can't really be true, or it wouldn't be running.
I wondered if I might remedy this by importing the System Table, MSysRelationships, from another recent backend Database, but I am told that I would need "Modify Design Permission" to even try that. I can find no way to get that permission on a .accdb Database.
I would appreciate any suggestions.