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

On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
<Prez1210@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.


[color=blue]
>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
>[/color]

"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
news:bq5u619qsojh5t3k43h73cte66r5jkmr8s@4ax.com...[color=blue]
> On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
> <Prez1210@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.[/color]

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

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" <randy@SpamFree.com> wrote in message
news:A3Mbe.1497$Ne7.121@newssvr17.news.prodigy.com ...[color=blue]
> "Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
> news:bq5u619qsojh5t3k43h73cte66r5jkmr8s@4ax.com...[color=green]
>> On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
>> <Prez1210@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.[/color]
>
> Yes, definitely. I've got a couple of systems doing just that, excellent
> results.
>
>[/color]

On Thu, 28 Apr 2005 00:16:53 GMT, "Jeff Harbin"
<Prez1210@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.

[color=blue]
>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" <randy@SpamFree.com> wrote in message
>news:A3Mbe.1497$Ne7.121@newssvr17.news.prodigy.co m...[color=green]
>> "Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
>> news:bq5u619qsojh5t3k43h73cte66r5jkmr8s@4ax.com...[color=darkred]
>>> On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
>>> <Prez1210@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.[/color]
>>
>> Yes, definitely. I've got a couple of systems doing just that, excellent
>> results.
>>
>>[/color]
>[/color]

"Jeff Harbin" <Prez1210@mindspring.com> wrote in message
news:VXVbe.507$pe3.68@newsread3.news.atl.earthlink .net...[color=blue]
> 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[/color]

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

--
Randy Harris
(tech at promail dot com)

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.spam.tom7744@cox.net> wrote in message
news:egf071lf0vooe83h4p8l3c559cdc2hnlf9@4ax.com...[color=blue]
> On Thu, 28 Apr 2005 00:16:53 GMT, "Jeff Harbin"
> <Prez1210@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.
>
>[color=green]
>>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" <randy@SpamFree.com> wrote in message
>>news:A3Mbe.1497$Ne7.121@newssvr17.news.prodigy.c om...[color=darkred]
>>> "Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
>>> news:bq5u619qsojh5t3k43h73cte66r5jkmr8s@4ax.com...
>>>> On Wed, 27 Apr 2005 03:35:20 GMT, "Jeff Harbin"
>>>> <Prez1210@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.
>>>
>>>[/color]
>>[/color]
>[/color]

> This is working better than I could ever have imagined.[color=blue]
>
> Once I figured out you don't actually put the word 'password' in front of
> the password.[/color]

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

Arno R