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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with asp & odbc linked table

Status
Not open for further replies.

lbarrow

IS-IT--Management
Nov 14, 2000
2
US
I have an access database with 2 native tables and one linked ODBC table. The link contains a user id and password that is passed to the remote database. I have an ASP page that allows the user to fill it out and it should update all 3 tables. It works perfect when I run it directly on the web server. If I go to another computer, it updates the 2 native Access tables, but not the ODBC linked table. No error message results. I assume it is a permissions problem with the IUSR_<computername> account, but I can't figure out how. I have given the IUSR account god authority to everything I can think of, but that is not working. FYI: I am not allowing anonymous access to the website. Can anyone help?
Thanks,
Lorraine
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top