Very Computer

by **derrick lakema** » Sat, 12 Oct 2002 04:30:12

I am new to this odbc stuff. I have inherited a NT4 IIS
website that uses asp and links to an access database on a
separate NT4 server. I have moved the site onto a new W2K
IIS server and set up odbc connections on this server to
the access database server. The two servers are on the
same domain with administrator and IUSER full control
rights to all directories on both servers. Help? Why do I
keep getting the below error?

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

P.S. Whenever I access a copy of the database on the local
D drive it works!

Thank you for any help!
Derrick

by **Rames** » Sun, 13 Oct 2002 00:21:36

I do see you mentioning that IUSR has full control on all the directories
on both server.
You do realize that IUSR_Webservername is a local account on the webserver.
Do you have the same account IUSR_WebServerNAME on the database server with
the same password?
if so, do you have the allow IIS manage the password unchecked in IIS.
The following article talks about this specific scenario.
HOWTO: Connect to a Remote Access Database from Active Server Pages
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q253580

Hope this helps.

Ramesh Thyagarajan, MCSD,MCDBA
Microsoft Developer support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Very Computer

ODBC connect from IIS server to Access server

ODBC connect from IIS server to Access server

ODBC connect from IIS server to Access server