ODBC to Database on mapped drive...

[morpheus000]

I am trying to setup an ODBC Source on a webserver (IIS 4, NT 4) to an Access 97 database which resides on a separate file server (from the web server).

I select a System DSN, Select the Access 97 Driver and then using the ODBC COnfiguration window 'browse' my way to the network location of the Access database. I do the same thing for the system database (workgroup) file.

When I try to connect to the source through an ASP page, 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.

I have verified the username and password in the connection properties and I know that the database is NOT opened exclusively by someone else. The account in the workgroup that I am authenticating against the database has Admin level rights.

Any thoughts or suggestions. What is the best way to setup an ODBC source to a DB stored on a remote file server?

Thanks in advance!
b

 

[tlbroadbent]

The real issue is likely NT permissions rather than Access persmissions. Does the web server account have permission to read/write the share\folder\file on the remote server? Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.