Microsoft Jet Database Engine error

[enigmaos]

Has anybody seen the error below?

I'm working on a login screen with VB.NET Web Application. I need to get data from Test.mdb (an Access97 database located on the network) and check the login/password. Test.mdb is being used by another application also.

Everytime, when the Web Form tries to fill a dataset (i.e. myDataAdapter.Fill(myDataSet, "tblLogin")), it just errors out with the error below.

The Test.mdb is shared and "Everyone" has FULL CONTROL permission.

What do I need to do to get rid of that error? :confused:


Server Error in '/Project1' Application.
The Microsoft Jet database engine cannot open the file '\\Server1\C\Program Files\Test1\Test.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file '\\Server1\C\Program Files\Test1\Test.mdb'. It is already opened exclusively by another user, or you need permission to view its data.


NOTE: I tried to link just the login/password table on the local machine (where the Web Application is), and it still returned the same error message.

[Cakkie]

I had the same error when trying to create a linked server in SQL Server to a database file. The problem is that the webapplication is running in IIS, which is a service. This means that IIS is probably running under the credentials of the SYSTEM account.

If you are using win2000 with a Active Directory, you will need to check the "trust this computer for delegation" checkbox in the "Active Directory users and computers" management tool.

You will also need to give the computer account on which IIS is running rights to both the share as to the files it is accessing.

[enigmaos]

I'm using Windows XP (where the application is built/compiled) and the Access database is on Windows NT 4.0

What do I need to do?