Database Backup/Recover

[progressiverookie]

Hi,

I am creating a database that has a total of 6 tables. I plan to distribute this database to a few people via CD-Rom, and am having some trouble with a backup feature I am trying to build. Because I am not very proficient with VBA code writing, I generally create a macro and use the built-in conversion tool to change it to code once I am done.

Here is my problem. One of the properties that need to be set while creating an "output" macro is the file pathname. Each user I distribute this database to will have a different file path depending on where they want the backup files saved. I would like to create a friendly, easy way for the user to identify the pathname in a form, which them sets that value in the macro/code. Is this possible? I hope I explained my problem clearly enough to understand. Thanks in advance.

Jeremy

 

[willir]

Jeremey

Store the destination in a table and allow the user to edit it via a form. Probably a good idea to test the target destination exists before committing the changed entry.

I usually use an Admin table for this type of thing.

Richard

 

[progressiverookie]

Richard,

How do I set the value from that table into the macro/code? How do I reference that filed in the table when running the macro/code?

Jeremy