OLEDbCommand Locks entire Access Db
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
Hi All I've created a pretty basic update command that uses oledbparameters that runs successfully. However, it locks the entire database (ie: no one else can use the Access database while the query is running) Also, if the database is open in MS Access, my query fails because the "file is already in use" what can I do to stop this. Can I specify a level of locking to use - optimistic, pessimistic, etc Thanks for any advice Jason