Remote Database Access using ASP

[chuck76]

I am trying to access a remote database separate from the web server by using a data connection on the database server (eventually a MS SQLServer but Access now).&nbsp;&nbsp;I want to be able to connect to a server on our network first and can't seem to get the syntax to work when I use the &quot;MS Remote&quot; OLE-DB provider.&nbsp;&nbsp;IS there another way to do it other than this provider?&nbsp;&nbsp;If not can someone help me with the syntax of the statement (particularly the &quot;Remote Server&quot; property).&nbsp;&nbsp;Here is my statement (modified):<br><br><br>conn.open &quot;provider = MS Remote; Remote Provider = Microsoft Access Database {*.mdb};Remote Server = \\networkserver; Datasource=data; &quot;