By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,479 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,479 IT Pros & Developers. It's quick & easy.

Logging onto a Remote Computer

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
<Pr******@mindspring.com> wrote:

Probably.
Open a command window, and type:
net use /?
Using this mechanism you can map a drive letter to your share
(including - it appears - speciafy a username and password), copy your
file, and unmap the drive.

-Tom.
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


Nov 13 '05 #2

P: n/a
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:bq********************************@4ax.com...
On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
<Pr******@mindspring.com> wrote:

Probably.
Open a command window, and type:
net use /?
Using this mechanism you can map a drive letter to your share
(including - it appears - speciafy a username and password), copy your
file, and unmap the drive.

-Tom.


Yes, definitely. I've got a couple of systems doing just that, excellent
results.
Nov 13 '05 #3

P: n/a
OK.

I've written the code to use a Shell command to open a cmd window but I'm
unsure how to pass the values to the cmd window once it's opened. Can you
point me in the general direction?

Thanks,

Jeff
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:A3****************@newssvr17.news.prodigy.com ...
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:bq********************************@4ax.com...
On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
<Pr******@mindspring.com> wrote:

Probably.
Open a command window, and type:
net use /?
Using this mechanism you can map a drive letter to your share
(including - it appears - speciafy a username and password), copy your
file, and unmap the drive.

-Tom.


Yes, definitely. I've got a couple of systems doing just that, excellent
results.

Nov 13 '05 #4

P: n/a
On Thu, 28 Apr 2005 00:16:53 GMT, "Jeff Harbin"
<Pr******@mindspring.com> wrote:

Once you map a drive letter, say X:, you can then copy the file to the
X-drive. Then you run a second command to unmap the drive.

Btw (perhaps this is your question), to use any command use this
syntax:
dim strCmd as string
strCmd = "cmd.exe /c net use <etcetera>"
Shell strCmd

-Tom.

OK.

I've written the code to use a Shell command to open a cmd window but I'm
unsure how to pass the values to the cmd window once it's opened. Can you
point me in the general direction?

Thanks,

Jeff
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:A3****************@newssvr17.news.prodigy.co m...
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:bq********************************@4ax.com...
On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
<Pr******@mindspring.com> wrote:

Probably.
Open a command window, and type:
net use /?
Using this mechanism you can map a drive letter to your share
(including - it appears - speciafy a username and password), copy your
file, and unmap the drive.

-Tom.


Yes, definitely. I've got a couple of systems doing just that, excellent
results.


Nov 13 '05 #5

P: n/a
"Jeff Harbin" <Pr******@mindspring.com> wrote in message
news:VX**************@newsread3.news.atl.earthlink .net...
OK.

I've written the code to use a Shell command to open a cmd window but I'm
unsure how to pass the values to the cmd window once it's opened. Can you
point me in the general direction?

Thanks,

Jeff


Jeff, I think Tom's got you on the right track. Post again if you have
questions.

--
Randy Harris
(tech at promail dot com)
Nov 13 '05 #6

P: n/a
Thank you...

This is working better than I could ever have imagined.

Once I figured out you don't actually put the word 'password' in front of
the password.

Thanks again.

Jeff
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:eg********************************@4ax.com...
On Thu, 28 Apr 2005 00:16:53 GMT, "Jeff Harbin"
<Pr******@mindspring.com> wrote:

Once you map a drive letter, say X:, you can then copy the file to the
X-drive. Then you run a second command to unmap the drive.

Btw (perhaps this is your question), to use any command use this
syntax:
dim strCmd as string
strCmd = "cmd.exe /c net use <etcetera>"
Shell strCmd

-Tom.

OK.

I've written the code to use a Shell command to open a cmd window but I'm
unsure how to pass the values to the cmd window once it's opened. Can you
point me in the general direction?

Thanks,

Jeff
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:A3****************@newssvr17.news.prodigy.c om...
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:bq********************************@4ax.com...
On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
<Pr******@mindspring.com> wrote:

Probably.
Open a command window, and type:
net use /?
Using this mechanism you can map a drive letter to your share
(including - it appears - speciafy a username and password), copy your
file, and unmap the drive.

-Tom.

Yes, definitely. I've got a couple of systems doing just that,
excellent
results.

Nov 13 '05 #7

P: n/a
> This is working better than I could ever have imagined.

Once I figured out you don't actually put the word 'password' in front of
the password.


Jeff,
Just interested...
Would it be possible to post the result-code of what you have figured out ?

Arno R

Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.