I have an Access 2000 ADP application and MS SQL 7 and when the user opens it on a second computer (and a seperate application) they get the message that the tables are read-only.
When I try it in my office on 2 computers I don't get it.
What should I be looking for?
Michaelthat essentially says that you open the file in exclusive mode. If you have this setting (its the default I believe) then if you can't get it in exclusive mode, it becomes read only.
I might have this wrong in that if a machine grabs the file in exclusive mode it might be locking out the others.
Check the settings on your machine(s), I believe its under Tools-Options-Advanced.
HTH|||I did not think you could open the tables in an MS SQL 7 database exclusively. I know you can when using an .MDB back end.
Are you sure this is the case? I will look at it on my server side.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment