I have an Access 2000 database that is linked to some SQL tables from another program within my company (Progression Workflow Explorer/Macola), and whenever a user is accessing one of those tables from my database, it locks up other users using Macola. Is the access database responsible for this? I have heard in the past that Access has trouble dealing with lockfiles and such, but I do not know if this is relevant. Thanks in advance for any help you can provide!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Tables being locked...need help.
- Thread starter sunmorgus
- Start date
It really depends on how you are accessing/updating the data source. If you are only using read-only access - there should be no problem. If you are updating, via a Linked Table, then MS Access may attempt to lock the entire table in some cases. My approach is to use ADO and execute SQL Insert/Update/Delete commands and avoid Linked tables as much as possible. htwh,
Steve Medvid
"IT Consultant & Web Master"
Chester County, PA Residents
Please Show Your Support...
Steve Medvid
"IT Consultant & Web Master"
Chester County, PA Residents
Please Show Your Support...
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Helpful tip