Access 2007 Migration & Export errors - Error #3021 "Invalid relation. no current record" & "No read access to System Tables. Modify Access db before retrying"

Question

Hello,

I am attempting to migrate a Microsoft Access 2007 database via SQL Developer version 2.1.1.64. When I tried to connect to the Access 2007 database it continues to return the error "No read access to system tables. Modify Access tables before retrying". However with Access 2007 there are no User permissions that can be altered and I thought every table had read access. Is this different for the MSysObjects, MSysQueries and MSysRelationships tables? Can I change read access to these tables?

Then I attempted to use the the Microsoft Access 2007 Exporter in the SQl developer tool and then it returns the error " Error #3021 - Invalid Relation. No current record." Although there are clearly many records and relationships in the Access database.  Does this error mean some of the tables have relationship errors?

If anyone can help, I would definitely apprecite it. 

Thanks in advance for the help!

Answer 1

http://forums.oracle.com/forums/thread.jspa?threadID=1010216&tstart=45#4017333

it says: (and it works)

Microsoft changed things around for Access 2007 (they have clearly never heard of the maxim: "If is ain''t broke, don't fix it!".

Try this...

1. Open your database in Access 2007.
2. Click the "Office button" in the upper left-hand corner and "Access Options" from the pop-up.
3. Click on "Current Database".
4. In the "Navigation" section, click on the "Navigation Options..." button.
5. In the lower left-hand corner of the "Navigation Options" pane, make sure "Show System Objects" is checked; then click "OK".
6. Click "OK" on the "Access Options" pane.
7. On the ribbon, click "Database Tools", then "Users and Permissions", then "User and Group Permissions".
8. In the "User/Group Name" window select "Admin" (if it is not already selected); then scroll the "Object Name" window until you come to the "MSysXXX" objects. Some of these already have "Permissions" boxes checked; leave them alone. Check the "Read Data" box for the others.

Answer 2

You might try here:

http://support.microsoft.com/kb/964467

or if that isn't what you need here is a list of many causes of that error:

http://support.microsoft.com/search/default.aspx?mode=r&query=Error+%233021&spid=global&catalog=LCID%3D1033&1033comm=1&ast=25&ast=28&res=20

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire