Hello Again,
I have another connection problem to address. This one involves the web server in our own network where we host our school district web site. In short, when attempting to create a record set, I get a permissions error and I cannot view any of the tables of the database. First, some notes about the site:

1. The web server is IIS 5.0 running on Windows 2000 Server.
2. The URL Prefix configured in Ultradev 4 for the site is www.valverde.edu/
3. The Access 2000 database is on the web server and part of the web site in a directory called, "Databases".
4. Ultradev 4 is installed on a machine that is different than the web server, but in the same domain.

I will approach this problem in a series of steps:
1. I created the DSN on the web server and it points to the database in the "Databases" directory in the web site.
2. After creating the DSN, I return to the page in Ultradev 4 where I want to create the record set, and define a new DSN.
3. After naming the connection, I select "Using DSN on the Application Server", and then I select the DSN.
4. I select the connection, OK, OK, Done.
5. At this point, I get an error message that says, "Unable to retreive tables from this connection, click on the 'Define...'button to test this connection".
6. After clicking OK on the error message, I go back to "Define", select the connection, Edit, Test.
7. At this point, I get "message 2" (follow this link to see the message: www.valverde.edu/errormsg.htm).

The following have been suggested to me as possible reasons for this problem:

1. There is a problem with the permission's on the directory that contains the database on the remote system. The problem is may lie with the IUSR_[machine name] account on the web server not having permission's to the directory where the database is located.

2. The web server runs as LOCALSYSTEM, and does not have access to drive mappings that I have access to when I log on to the web server.

I have not fully investigated these ideas, but wanted to put this out there to see if anyone has run into this, or might have some idea about fixing the problem. Thank you for your help.

-CD