Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Security issues accessing a Database

Status
Not open for further replies.

Wakestrap

Programmer
Jun 5, 2003
10
CA
I am trying to access an access database through an ASP page. I have IIS setup on my personal machine and can run the script without error from any machine in the office. But when I try to setup the codeup on our company Intranet(running of a win 2000 server, sharepoint based) it fails to work and I get an error with this line of code:
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("emplist.mdb")
the error being ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process
I have narrowed it down to a privlages issue based on the fact that when I access it as a system administrator with access to EVERYTHING it works... I'm wondering if theres some IIS setting or perhaps permissions to DLL's... I just cant figure it out.
Cheers
Wake
 
I've made the change but I think I have to wait until the server is rebooted for the changes to take effect. I cant reboot until this evening but that should hopefully solve the problem! Much thanks,
Wakestrap
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top