Hi, I want to connect to a remote server to connect to a database that is on a different ftp. I currently use the following code to connect to the database on the same ftp, but want to change it so it will connect to the database now on a different website/server. <% DIM CONNECT,DBCONN,SQL CONNECT="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("DBASE/USERMAN.MDB") Set DBCONN=Server.CreateObject("ADODB.Connection") DBCONN.OPEN CONNECT %> Code (markup): How can I do this? Regards,
Hello, Access not allow remote connection. But you required to change the "Data Source" property according to your new server. Also required to shift your .mdb file to new FTP.