Could not use "unknown" File already in use error msg

[agatha]

I transferred my web application to a different computer and now I am having problems with my connection (dsn connection) to my database. I keep getting a Could not use "unkinwn', file already in use error message apparently related to odbc drivers. Can anyone help here please?

 

[avivit]

This thing can happen out of 2 reasons (had this problem recently, but solved it):

1. In the code itself: recordsets/connections are not closed properly.
Could be that u open a recordset but never close it, etc.
Since u got it work until u tranfered it to another comp, I'd say u have the 2nd problem, which is a permission problem:
2.(Not in the code) The administrator should do this actually.

In general (I quote a person who helped me out):

"if you have not the correct permissions,
when you open the database, you cannot unlock it, which means that any other user will find the database file "blocked" and will not be able to open it."

The following url explains it:

http://support.microsoft.com/support/kb/articles/Q174/9/43.ASP