Save Output to System Name - "A Different Harddrive"

  • Thread starter Thread starter lgray
  • Start date Start date
L

lgray

To the All-Knowing MVPs:
Is there a way to save an Access "Output To" to a specified computer within
the office I'm working in. As a readily available backup, my supervisor has
requested for me to send outputs of Key database tables to one computer in
the office. The database resides on the network, everyone accesses it, and
I've implemented the Output To function to hit the C drive. But instead of
hitting the user's C Drive, he wants it to hit an unused system with the
System Name - G000089387.

Any/all suggestions on this would be helpful.

Thank you in advance.
 
If you can see the computer under the Windows Network in the File Explorer of
a Save dialog, its just a matter of getting the syntax correct. Probably
something along the lines of

\\[Machine Name]\Folder\Folder\Folder

or you should be able to map a drive letter directly to it.

Google UNC (Universal Naming Convention).

You just have to be certain the user ID that's logged on to the PC running
the Access database has write permissions.

If you've used the Windows CommonDialog box via code, you should be able to
obtain the UNC from there.
 
Not only did I get help with the Programming but also got humour and
joviality. Can't beat that...
I was able to find the computer on the network when I used search function
of My Computer and plugged in the computer name into my code. It looks like
it tries to perform the output, but then gives me the message, "Can't save
the output to the file you've selected". I will see if the techies here can
see where my syntax is off on the location.

Thank you for your help.
--
Linda


dch3 said:
If you can see the computer under the Windows Network in the File Explorer of
a Save dialog, its just a matter of getting the syntax correct. Probably
something along the lines of

\\[Machine Name]\Folder\Folder\Folder

or you should be able to map a drive letter directly to it.

Google UNC (Universal Naming Convention).

You just have to be certain the user ID that's logged on to the PC running
the Access database has write permissions.

If you've used the Windows CommonDialog box via code, you should be able to
obtain the UNC from there.

lgray said:
To the All-Knowing MVPs:
Is there a way to save an Access "Output To" to a specified computer within
the office I'm working in. As a readily available backup, my supervisor has
requested for me to send outputs of Key database tables to one computer in
the office. The database resides on the network, everyone accesses it, and
I've implemented the Output To function to hit the C drive. But instead of
hitting the user's C Drive, he wants it to hit an unused system with the
System Name - G000089387.

Any/all suggestions on this would be helpful.

Thank you in advance.
Click to expand...
Click to expand...
 
Back
Top