Database opening problem

[mdr227]

I do much of my ASP development on my local machine and setup the same DSNs for the access dbs used on the IIS server. However, I frequently receive error messages like the one below even though the file is not open and has not been opened for some time. Do you know what I can do to overcome this? THanks.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

 

[onpnt]

do you close the connections to the database at ALL times in your scripts when you are done with it?

more then likely there is a .ldb still stuck somewhere

otherwise we need more details of the scripts as in what they are doing, how you use the database and or how the production is differing.

final note: I suggest the usage of DSN-Less connections.

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page