Query Become read Only

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

I have simple query, which has join of 3 tables.

The database is sql server 2000 to access 2003 by ODBC.

After i change the odbc connect to another database with the same structure
but with diffrent indexes my query becomes read-only.

All the tables can be read or write or when i set Daynaset(Inconsist
updates) it works fine. But it is not the solution because all the query
baset on that query also become read-only.

What can cause it, and how can i solve it?
 
Whell Jeff

As request of one of the programmers we use only with one DSN and change the
database name in the properties of the connection

Because he don't want to hold DSN for each database.

The table it self can be updated but the query not.

what can cause the problem now?
 
Back
Top