Question Copy A Folder To Location Selected By The User

[Learn2010]

I have a folder with Access files, subfolders, and some .vbs files in it. It requires one person to navigate through a setup process. Once the setup is completed, they need to copy the folder and its contents to a location on a shared drive, which is unknown to me and will be chosen by the user at the site. There could be many sites.

It basically works like this:
Files are downloaded to C:\Program Files.
A vbscript is run and extracts a folder directly to the C:\Drive and opens it. I'll call it C:\Test.
The user manually moves the BE file to a shared drive.
The user opens the FE file and is walked through using the Linked Table Manager.
The user then follows a series of forms to input data.
After this, the FE closes and another DB opens.
The second DB walks them through the Linked Table Manager and closes.

Option #1
At this point I would like to have a script and have it copy that folder, C:\Test, and its contents, and have a dialog box open telling the user to paste it in a location where all users have access to.

Option #2
A script that will backup the folder and all its contents to a shared location selected by the user.

Either option will l allow others to navigate to that location, copy the folder, and paste the folder to their C:\ Drive.

Can anyone do that? Thank you.

 

[PaulO]

Cleverer people than me will give you the solution you've asked for ... all I would ask is why you are managing files in this way?

This simplest route to glory is for all users to use a common folder on their hard drive or for you all to use the same BE on a shared server. This way no-one has to use the Linked Table Manager.

 

[Learn2010]

If it was here onsite I would do that. However, it is going out to several sites not at this location. Each site is different. I am only trying to control what I can with the skills that I have and rely on things like this forum to maybe take me to a higher level.

Thank you.