>I have the odbc connection on the web server to this table and I have tried one to a database container for this table. Neither worked. When the table resides on the server the odbc works?
It probably does not have rights to access the directories on the remote machine. When ASP acts on something it uses the IUSR_MachineName account. By default, this account is given limited rights on an NT system. Go into the remote directory and grant the appropriate rights and see i that takes care of it.
NOTE This may open some security holes so be sure to only grant rights to the minimum that is needed.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao