The link has all possible connections to Access DB's with source included.
Best Regards, Josh Crouse http://www.rablat.net http://www.able-consulting.com/ado_conn.htm?f=ado_conn.htm#ODBCDriverForAcce ss -----Original Message----- From: Eric Levine [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 12:58 PM To: ActiveServerPages Subject: DSNLess Connection to Remote MS-Access DB Good afternoon to all, Quick question.. I am in the process of creating an application that will go across multiple web servers. Can someone please help me with the code necessary to connect to an Access DB that is located on one server, from ASP code on another. I understand that HTTP is not acceptable in the connection string so I am a bit stumped on how to recognize the .mdb file on the remote server. Example: Server 1 - Connection String objSConn.Open "Provider = Microsoft.Jet.OLEDB.4.0; " & _ "Data Source = http://www.dbstore.com/data/test.mdb"; Server 2 - .mdb File on server www.dbstore.com c:\data\test.mdb Many thanks in advance. Regards, Eric --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
