I have an Access 2000 database which saves (exports) of copy of the main
data table each time it is opened. It continually over-writes the same file
so I've got a back-up if anything were to happen to the original.

I'm doing this using a macro named 'AutoExec'. I can write the code to do
it in VB and I suspect I will have to do that to accomplish what I'm trying
to do.

I've historically saved the back-up file to a zip disk but I want to change
this to a more secure location. I've mapped a drive on my computer to the
folder on the machine (which is different than the machine where the
original database is located) that is to contain the saved back-up.

The problem is this computer requires a log-on to access any of the folders.
If I manually log onto the drive using Windows Explorer everything works
fine and continues to do so until I reboot the original computer and then it
won't export it until I manually log onto the back-up computer.

Can I code this to pass the password to allow me access to the drive.

Both computers are using Windows XP.

Thanks

Jeff