updateable problem

R

Roy Goldhammer

Hello there

I have Access Application that the data is on sql server connected by link
tables.

After i transfered to another databse on sql server by link table, Suddenly
some of the quries, which has many joins, become read only.

the only way now to solve it is by changing the Record type to
Dynaset(Inconsist updates). and it isn't work in all other tables.

My question is? what can cause it and how can i fix it?

any help would be useful
 
A

Allen Browne

Roy, here's a list of things to check:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

Since you talked about moving the back end, and nothing else obvious
changed, is there any chance that one of the tables does not have a primary
key? Adding a primary key can sometimes fix the issue.
 

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

update data on query 2
query links to SQL server and mdb table 1
Query not updateable 3
Query Become read Only 2
Data entry denied in a query. 6
Dynaset, inconsistent updates 20
Help! Need to update linked SQL table in Acc07 3
updateable query 2

Top