Virtual Network Drive

[mschirle]

Hi,
I have a front end back end database. I use this at work but I work on
it at home also. I would like to link the back end via UNC but if I do
that I can't use it at home because I'm not on the network. Currently
I use subst to create a virtual drive at home. Can I create a virtual
network drive on my home computer to simulate the environment at work?

Thanks

 

[Brendan Reynolds]

Hi,
I have a front end back end database. I use this at work but I work on
it at home also. I would like to link the back end via UNC but if I do
that I can't use it at home because I'm not on the network. Currently
I use subst to create a virtual drive at home. Can I create a virtual
network drive on my home computer to simulate the environment at work?

Thanks

Well ....

You *could* use Virtual PC to run a virtual server on your home PC with the
same name as the real server at work. I use Virtual PC to run a virtual
server on my laptop, and it works quite well. It does require plenty of RAM
though, because you need enough RAM for both the real PC and the virtual
one.

Alternatively, just add some code to relink the tables at startup. There's
code to do this at the following URL ...

http://www.mvps.org/access/tables/tbl0009.htm