Hello all



I have a problem. I am building a vb application that needs to be able to 

switch its ms access database connection between a local db and one that 

is posted on the web. Is there some kind of fancy-schmancey way that I can 

make the ado connection do that? 



(If you're wondering why, its kind of like using a disconnected recordset, 

but I want to be able to write & snyc with the online one) 



Thanks 



Me :)

The only thing that comes to my mind is replication--see the help files.

It's way non-trivial though...



Cheers,



-Roy



-----Original Message-----

From: Evan Miller [mailto:mesonuts@h...]

Sent: Thursday, May 10, 2001 3:08 PM

To: Access

Subject: [access] Dual mode database access





Hello all



I have a problem. I am building a vb application that needs to be able to 

switch its ms access database connection between a local db and one that 

is posted on the web. Is there some kind of fancy-schmancey way that I can 

make the ado connection do that? 



(If you're wondering why, its kind of like using a disconnected recordset, 

but I want to be able to write & snyc with the online one) 



Thanks 



Me :)