Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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
3
Medium Priority
?
2,691 Views
Last Modified: 2013-12-16
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?
Thanks!
0
Comment
Question by:rdani08
  • 2
3 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 1500 total points
ID: 39713032
If this error 'just started happening', your database might be corrupt:

http://granite.ab.ca/access/corruption/symptoms.htm

(See the 6th symptom)

I would try (starting with the simplest) -

- Compact/Repairing
- Creating a new table an copying the data
- Importing objects into a new database

... basically any of the steps to resolve corruption.
0
 

Author Comment

by:rdani08
ID: 39715564
Compact/Repair does not work.

Importing did not work as it said there was too much data to import. (many of the records in the main inventory table have small jpeg's as attachments...the total size is 220 MB). It worked when I attempted to import the data from an older version that was 130 MB

There are 51 tables in the database, Is there a way to know which ones to recreate vs copy?
Thanks
0
 

Author Closing Comment

by:rdani08
ID: 39722135
Importing objects worked to a certain extent.  I ended up having to write a query to export the data from the main table to excel and import it back to the new database.  The only data that was lost were the attachments.  Also, I had to copy all queries from an older version because when they were imported each field had an "Expr" added to it.
Thanks for your help.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question