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.
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.