I hope someone here can help with this, because I've been looking for a solution for a LONG time.

I have a front facing web server running win2k advanced server which has an asp application on it. The application needs to use the same databases that are on our intranet web server running win2k server. The front facing server is an AD Domain Controller.

I've given the IUSR_machinename account full control to the databases and tried to both map a drive from one server to the other and to use full UNC paths, but the odbc link still fails. When trying to browse the sight the error message is:

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

Of course, the database isn't opened by another user, so I'm assuming it must be a rights issue.

My question is: what else can I do, other than granting full control rights to the anonymous user on the front facing server as I already have done, to allow the asp pages to access the databases on our intranet?

Any help would be appreciated, I'm getting nowhere fast.

See the archive http://p2p.wrox.com/topic.asp?TOPIC_ID=8791 and http://support.microsoft.com/?kbid=161333

Also, you are using the wrong driver. For ASP you should use the Jet OLEDB driver, not the ODBC driver.