Remote Desktop Connection

[Ken OHanlon]

I have a question when using “Remote Desktop Connection” with the option selected to connect with my local drives. As you know when you select Explorer, it lists the remote computers hard drive tree first followed next by your own computers hard drives tree. My question is what is the correct path name back to your own C: drive? In explorer its listed as “C on MyComputer”. Does that make it \\MyComputer\C:? And if thats correct, how can you thu Access programming determine the “Full Computer Name” of your computer. What is the variable name of “MyComputer”? Thanks- Ken

[maxamis4]

Does that make it \\MyComputer\C:?
No that is incorrect. The machine name can be found by right clicking on my computer and looking in the Computer Name tab. The mapping would be \\[YOUR COMPUTER NAME]\C$. However by default windows blocks this type of access to prevent your data from being ripped from your C: drive. You will have to go into computer managment console and allow your C drive to be shared.

how can you thu Access programming determine the “Full Computer Name” of your computer?

There are many ways. You can google MS Access API computer name or you could even go through WMI which is the preferred. Before I continue any further I have to ask how well do you understand programming. The next bits of information will require some knowledge to get by. But if you google MS Access+WMI+computer Name you will get what you want.

[Ken OHanlon]

Does that make it \\MyComputer\C:?
No that is incorrect. The machine name can be found by right clicking on my computer and looking in the Computer Name tab. The mapping would be \\[YOUR COMPUTER NAME]\C$. However by default windows blocks this type of access to prevent your data from being ripped from your C: drive. You will have to go into computer managment console and allow your C drive to be shared.

how can you thu Access programming determine the “Full Computer Name” of your computer?

There are many ways. You can google MS Access API computer name or you could even go through WMI which is the preferred. Before I continue any further I have to ask how well do you understand programming. The next bits of information will require some knowledge to get by. But if you google MS Access+WMI+computer Name you will get what you want.

I can not seem to get it to work. Both the remote connection computer and my computer are SHARED. This is my code on the remote computer:

strDestinationDrive = "\\KenMain\C$tmp2.xls"
DoCmd.OutputTo acOutputTable, "tmp1", acFormatXLS, strDestinationDrive

MS says error 2302, "can't save the output data to the file you've selected"
Thanks in advance -Ken.

[maxamis4]

I
strDestinationDrive = "\\KenMain\C$tmp2.xls"
DoCmd.OutputTo acOutputTable, "tmp1", acFormatXLS, strDestinationDrive
.

here is what it should look like strDestinationDrive = "\\KenMain\C$\tmp2.xls"

but as mentioned before, just sharing in Windows will not give you access to the C: drive by default. For acess to the c: or the root you will need to modify permissions under computer managment console under the disk management window.

[Ken OHanlon]

here is what it should look like strDestinationDrive = "\\KenMain\C$\tmp2.xls"

but as mentioned before, just sharing in Windows will not give you access to the C: drive by default. For acess to the c: or the root you will need to modify permissions under computer managment console under the disk management window.

I never heard of the "computer managment console" or the "disk management window" but I gave it a try. I did not win! I got to where it asks for "Another Computer" but each time I entered MainComputer it said the network path was not found. I then tried logging into MainComputer and gave it MyComputer, but that not right too. What am I doing, what am I doing wrong? Help -Ken.