Could Not Use File - Already In Use

[ChloeRadshaw]

This is driving me nuts - I have read many posts on this but here is the deal:

The file and folder is read / write by EVERYONE
Access creates an LDB file - Now what happens if someone else updates the database at exactly the same time??? It also tries and creates an LDB file??

In that case windows will throw a file sharing violation.

Does anyone know how to update Access without it creating these stupid LDB files??

My connection string is Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sdbLocation


Please help - This has kept me up all weekend!

[OBP]

It would normally only create 1 .ldb file.
Why are you using a connection string rather than using Access?

[ChloeRadshaw]

I am using Access from within Excel.

Are you saying that only one ldb file is created and shared across users? Is this possible in the windows OS implementation?

[OBP]

Normally yes, especially if you invoke Security.
You should be able to test the .ldb file by opening it with Word or Wordpad to see who is in the database.