Problems with simultaneous connection to Access DB

  • Thread starter Thread starter Strange Cat
  • Start date Start date
S

Strange Cat

Hello everyone!

I have some apps (aspnet and windowsforms) that need to connect at the same
time to an access db.

It used to work fine before I installed the framework 1.1 service pack 1.
Now the problem is that the connection is opened by one of the two
applications, but sometimes I get on the aspnet applications an error saying
"cannot lock database file...", now this is weird! I didnt ask to lock the
file! (actualluy i do have in the connectionstring share deny none in both
applications!).

B4 installing the sp1 I could open both connections with (nearly) no
problem. (Nearly: I got sometimes errors opening but I wrapped the db.open()
into a do loop and trying a couple of times was enough to get the connection
open).

Any ideas?

Thanx in advance
ASC
 
[CUT]

Sorry everyone!

Stupid me! It was a permission problem on the folder containing the DB!
Anyway it's kinda weird if you don't set the permission ON THE FOLDER
containing the Access DB, aspnet thru adonet will *SOMETIMES* open the
connection and *SOMETIMES* won't...

Anyway, fixed.

Again apologies.

ASC
 
Back
Top