Access DB error after moving to SP2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Access Db that all the macros and queries run fine until I upgraded
the Office SP (version 11) product to SP2. Now I get an error that says
'Operation must be an updatable Query' Nothing has changed in the query.

As I said it runs under Version 11 of Aceess sp1 or prior, how or where
should I look to fix this?

Or what did SP2 do to break this?
 
check the file permissions on the db at the NTFS level

the user doesnt have Write permission
 
Thanks, for that idea, but I am a domain admin and the tables are attached
tables from SQL Server 2000. When I attached the tables I attached them with
an account that was a DBO level user.

As I said it works un Accesss XP sp1 or prior, but not SP2 or greater.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 db's & problems exporting query to Excel 1
Moving to 2007 1
Problems converting old DB to Access 2007 1
Too few parameters error with a IIF statement 5
Moving Access DB to MS-SQL Server 3
Access 2007 - Query Design View Error - " is not a valid name... 13
Access #Error & Excel Pivot 0
Access DB has become troublesome - Please try to help! 30

Back
Top