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
Thanks,
Lorraine