How do I fix an error "Could not read definitions; no read definition permission for table or query " in Access 2007?
Posted on 2013-12-11
I have an Access 2007 database that has been functioning properly for several years. A full version (.accdb) resides in a shared folder on the server. The primary user opens the database directly on the server (via a shortcut on the desktop). The other users have custom front end databases on their desktops (where certain fields are locked to view only). Recently, all of the users with front end databases are able to open the database but cannot open the Inventory Form from the Main Menu. They get the error: "Could not read definitions; no read definition permissions for table or query ". The database can be opened from multiple computers directly from the shared folder on the server. I recreated a front end version for the primary user and placed it on her desktop. When the tables are linked to the database in the shared folder it functions properly for her, however it does not on the other computers on the network. The same error occurs. The database was created in Access 2007, so there are no workgroups or users. How can I correct this error?