Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    17

    Unanswered: message that the tables are read-only

    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?

    Michael
    Thanks for your help, Mitch

  2. #2
    Join Date
    Nov 2002
    Posts
    19

    There is a setting on MSAccess

    that 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
    DerFarm
    It IS as bad as you think
    and they ARE out to get you

  3. #3
    Join Date
    Mar 2003
    Posts
    17
    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.
    Thanks for your help, Mitch

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •