Query Become read Only

[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?

 

[Jeff Boyce]

Does the "other dataset" have the same permissions as the first?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Roy Goldhammer]

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?