McFly... (hover boards coming??)

Are you just linking the tables from one mdb to another. Just that one mdb is online instead of on a network server/hd ?


The Docmd thing is a built in function of Access, which means you'd need the access references in there.

How are you connecting atm ?
- is it a linked table (surely thats so slow...) ? Can you link through the get external data ?


oConn.Open "Provider=MS Remote;Remote Server=http://myServerName;DSN=???;Uid=myUsername;Pwd=myPassword;"

I haven't used the remote connections, but perhaps RDO is better here than ADO ?? Worth a look ?
If the DSN can be saved from your computer, and yet still be flexible for other users this might be one way.

Go to the microsoft site, find a support email addy and send them the question - see what they recommend ?

If you have time, go to a book store or library n look up the RDO/remote connections/Net databases/Net programming... might have some use ful pointers there.

Good luck

Vince