Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Dallas
    Posts
    8

    Unanswered: ldb file issues with shared SQL links

    I am using Access 2000 application which uses linked tables to MS SQL 7.0 tables. Only switchboard and temp tables contained within mdb. If I place a separate copy of this mdb on each user's workstation will I experience any record locking/sharing problems? How can I share one copy of ldb file?

    Sorry for all the posts, but these issues came up at one time and I am struggling to tackle them all. All input appreciated.

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    Your locks are determined by the database that contains the data, in your case SQL Server. You can test any update anomalies by opening two instances of the front-end database on your machine and update the same record.

Posting Permissions

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