operation must use an updateable query

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

Guest

Hi all:

We are running Access 2002 and 2003. We use it to run queries on an SQL
datastore on a server in the same location as the client. We are running
2003 server with AD and SQL 2000(I believe)on the server. The queries have
been working correctly for a couple of years without any problem. Recently,
we changed the IP addresses on all machines including the server and the
clients running access. Since then the access database works fine until we
query the SQL datastore on the server. I have checked folder and database
privileges(access rights, etc). I am sure I have missed something somewhere.
Any ideas???

Thanks,

Michael
 
I have also compacted the access database and updated the links to SQl
database.
 
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

Operation must use an updateable query 13
Access 2010 append query to SQL is very slow 0
Pass Through Query - not returning rows 1
query links to SQL server and mdb table 1
Question on Pass-through Query 4
Am I disturbing a machine in production floor if I access its database remotely? 4
Update pass through query of report recordsource 2
Operation must be an updatable query 8

Back
Top