Hi, everyone. I've been working on an Access DB on a net share from a shortcut on my PC for the last few months. now I've accessed the net location of the DB and there are about fifteen generic db files: database1 (or whatever de default name for a db in english is), database2, database3 and so forth, with dates up to today (last time I've opened the db I've been working on).
Those dbs have a single table named MSysCompactError, with the same error on every record (instead of posting a SS in spanish I'll do my best translating the error description):
Error code: -1907 ErrorDescription: You don't have the required permissions to use the object 'XXXXXXX'. The system administrator or the person who created the object must establish the adequate permissions.
With XXXXX being a field of a table, query or form such as for example sq_cPuestos~sq_cUbicacion (puestos being the table and Ubicacion the field of said table)
The NTFS permissions of the original DB are set to full control for domain admins (only users with access to the net share the db is located at) and the db is working normally, not throwing any error or failing in any operation, but access keeps creating those additional db files with the aforementioned table. Any idea why or how can I fix it/prevent access from generating those files? And before you ask no, the MSysCompactError doesn't reflect which user is the one that doesn't have the required permissions.
Any help will be appreciated.