Hello, recently I split my database to protect the data. I created one database that houses the tables, which is password protected. The other database houses all the objects, and I created an ACCDE for the other users. Since I did this, the other users are not able to do things such as use my import commands (for which I created VBA) and update form fields based on table values.
When I try the same functions either on my backup objects DB, or the front-end ACCDE, I have no trouble. But the other users do. For importing, they typically get an error that reads "Type Mismatch." For populating a field on After Update of another field, they get an error that the "Tables" database is in exclusive use by another user, which is not the case.
Does anyone know how to fix this?
When I try the same functions either on my backup objects DB, or the front-end ACCDE, I have no trouble. But the other users do. For importing, they typically get an error that reads "Type Mismatch." For populating a field on After Update of another field, they get an error that the "Tables" database is in exclusive use by another user, which is not the case.
Does anyone know how to fix this?