Here's what I've got:
A web server running (IIS4.0), an MS Access database located physically on the same machine and a DNS set up (using MS Access ODBC Driver v3.50.360200) pointing to that local .mdb. The CGI app access the database and displays information from it. This works absolutely fine in this senario.
What I want to do:
I want to keep the IIS4.0 and the CGI app (web site) where they are (this machine is to become a dedicated web server). But the data has go to move to another server. How do I do that?
What I've tried:
I have placed the mdb on a share on another server. Given the original web server access to that share and changed the DSN to point to that share using a UNC (e.g. \\servername\sharename\databasename.mdb). However I get the error:
Error: not connected-0000019703
[Microsoft][ODBC Microsoft Access 97 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've tried giving the anonymous IIS user account (e.g IUSR_SERVER1) full access to the share, I've tried mapping a network drive to the share and using that in the DSN (e.g. x:\databasename.mdb), I've looked at the NTFS security on the share but that's fine (everyone - full access). I've looked at pretty much everything I can think of but it looks like I'm missing something pretty critical.
Can you help. Note: I've allocated a high number of points to this because it's important. "Can't be done" will not get the points as I need a solution. Full points will be awarded to the person who provides a full solution to the problem.
Good Luck and thanks in advance!! I wouldn't say my life depended on it but....