SharonLove
Programmer
Hi!
I am executing a query to update a 2nd Access mdb database with-in a transaction (Update query).
Many records get updated through this query.
I am updating the records in the current mdb using a Join on a table in a 2nd mdb.
This is done with Ado connection:
I am using the jet provider 4.0, but the databases are jet 3.
So, the error says:
3052: File sharing lock count exceeded
How do I need to handle this for a customer receiving this error?
I am executing a query to update a 2nd Access mdb database with-in a transaction (Update query).
Many records get updated through this query.
I am updating the records in the current mdb using a Join on a table in a 2nd mdb.
This is done with Ado connection:
I am using the jet provider 4.0, but the databases are jet 3.
So, the error says:
3052: File sharing lock count exceeded
How do I need to handle this for a customer receiving this error?