Hello all - The following connection strings:
Conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/DB/em.mdb")
Conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\wwwroot\em\DB\em.mdb"
are the two I have always used successfully with Access (2003). A couple of questions if I may.
> Am I using outdated strings or ones considered no ideal?
> Can someone please assist with what I may have missed relating to the following very annoying brick wall:
I have new XP pro machine. While getting everything up an running all of my sites using Access which were previously runing fine using the above strings are now giving me the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xb9c Thread 0xe48 DBC 0x1164024 Jet'.
I have checked permission on the folder holding the .mdb files, the .mdb files them selves, turned of any antivirus, win firewall. All steps I am aware of fail to rectify the issue. Now I turn to Google - After spending an hour researching the issue I have found no advice outside what I have done. last step the ever so helpful Wrox members
BTW - I have now given the EVERYONE user full rights the the folder/file and still no joy :(
TYIA or your time...
Wind is your friend
Matt
www.elitemarquees.com.au