Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are in the process of switching over to Access 2007. We have numerous data tables in Access 2003 files.

In one case, the user has 2007 on his PC and opened the front end in 2007. No problems.

When the the user is done, he clicks a button that executes a macro full of update queries. The macro reaches the first query and halts. We get a message saying we do not have permissions to write to this linked table (2003 format). There were no security files involved. We re-linked from 2007, same problem. LAN permssions were ok.

I wound up having to import the tables to front end in order for the user to be able to do his job.

share|improve this question
Does the 2007 machine have a different OS than the 2003 machines? If it's Vista (instead of XP) there may be file permissions / user rights that need to be granted. – yhw42 Dec 21 '10 at 20:58

Turns out that this particular instance had linked tables and a macro with about 30 steps which 2007 would not execute.

Put the tables back in with the rest of the application and it works fine in either 2003 or 2007.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .