Short answer, you can't. Long answer, you can't, unless you have three months of your life to spare.
Using regular ASP, there is basically no way to communicate with remote Access databases (all of you who were about to say "RDO, RDO!" - don't, you'll get *such* a smack). You'll save yourself a million years of grief by using SQL or MSDE on the remote server. And then just wait until you have to work out how to upload files across a server :0) Scott. ----- Original Message ----- From: "Eric Levine" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, October 11, 2002 2:58 AM 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%% > __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
