>>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.
Also, is Fetch Data in Background turned off?
http://support.microsoft.com/support/kb/articles/q269/8/81.asp