ODBC Error 80004005 When using UNC Connection to Access 2002 database

[harleychick]

The facts:
Using Visual Interdev 6.0 on Windows XP
Using IIS 5.0 on Windows NT Server for web server (Call it SERVER_X)
Developed a Microsoft Access 2002 database in a shared folder on a separate server (Call it SERVER_Y).

I am trying to connect to the database using DataEnvironment connection through Interdev. I have a System DSN (MyDSN) setup on both the local machine and on the server. The DSN on the two machines have the same name and use a UNC Connection to the database located on SERVER_Y. The global.asa file only connects using the connection string DSN=MyDSN. The IUSR_SERVER_X account has FULL CONTROL to the share on SERVER_Y that contains the Access Database. I can view data in the database thru the Interdev on the local machine.

I am using an ASP page with a recordset DTC to access the data in the database (I have used recordset and grid DTC's successfully with SQL DSN's).

However, when I pull up the ASP page via the web, I get the following error >:-< :
---------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[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.

/TnkLvls/LiquidAlum148.asp, line 149
-----------------------------------------

Please Help!! What is wrong??? I am very frustrated!!

Thanks!

 

[talbalazs]

Hi,

i am having absulutaly the same situation. I tested windows 2000b and XP. Both systems hav this problem. I have found som suggestions in internet, but still no solution! I am disappointed!

 

[vbkris]

o.k the problem maybe that someone has opened the access file (using microsoft access).

Known is handfull, Unknown is worldfull