I'm trying to access a database stored locally on each machine accessing an admin page. The Database is stored on the local machines C: drive in a directory called database (c:\database\dfg.mdb). using the following connection:
DataConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\database\dfg.mdb"
When I run this on my development machine using Personnel Web Manager everything works fine and I can read from the Database. However once the page is uploaded to a Web Server I get the following error:
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x744 Thread 0x1af4 DBC 0x1589024 Jet'.
I think the above is telling me it can't open or find the Database but i'm not sure.
Any help would be most welcome.