I have an encrypted Kingston USB drive which I use on a computer at work and on another at home. Some folders on my USB have Access front-ends which link to a back-end database in another folder on the same USB.
At work, when I log onto the USB it uses two drive letters F and G. G is where all the data is, I guess F holds the security or something. I don't really understand that part!! So my front-ends all point to G:\Work\Data…etc.
But when I plug it in at home, it uses G and H. So now my back-end tables are on H and I have to use “Linked table manager” in my front-ends and refresh them each time. And then do the same when I come back to the office. Not difficult, just becoming a pain in the ass!
I don’t have admin rights to change the computer at work, but is there a way to force my computer at home to use F and G? I’m on Windows Vista at home if that makes any difference. Just now I can’t remember what F relates to on my home computer. It might be the CD-drive, which I rarely use.
I have found links to USBDLM but I don't know if that's the best solution.
Thanks
At work, when I log onto the USB it uses two drive letters F and G. G is where all the data is, I guess F holds the security or something. I don't really understand that part!! So my front-ends all point to G:\Work\Data…etc.
But when I plug it in at home, it uses G and H. So now my back-end tables are on H and I have to use “Linked table manager” in my front-ends and refresh them each time. And then do the same when I come back to the office. Not difficult, just becoming a pain in the ass!
I don’t have admin rights to change the computer at work, but is there a way to force my computer at home to use F and G? I’m on Windows Vista at home if that makes any difference. Just now I can’t remember what F relates to on my home computer. It might be the CD-drive, which I rarely use.
I have found links to USBDLM but I don't know if that's the best solution.
Thanks