Importing Tables and Appending Data From Temporary db

[CWH via AccessMonster.com]

I have created a user.mdb where data is entered into a variety of tables. I
have several people using the user.mdb independently on there own laptops. In
this db I have created a VB command that uses DoCmd. TransferDatabase which
exports data the User selects into a transfer.mdb
(receiver database).

This is new: The transfer database is new created automatically in VB and
the name changes depending on the date (example: transfer.mdb 2-11-2007,
transfer.mdb 2-12-2007, etc…).

I have created an admin.mdb with append queries which imports tables (the
administrator selects) from transfer.mdb database (once appended it updates
table data in the admin.mdb). The admin.mdb database is designed for an
Administrator to view data and print records etc.. The admin.mdb is also
designed to allow data entry, modify & delete.

Where I need help;

The transfer.mdb will be placed on the same computer or network as the admin.
mdb database.
Since the transfer.mdb name will change depending on the date, I am looking
for a way for a user in the admin.mdb database to be prompted for the
database name/folder location. Accordingly, create flexibility in the VB code
to import the tables. Currently the VB code is looking specifically for a
“transfer.mdbâ€. The code needs to be written to allow for the changing name…..
if possible.

 

[Douglas J. Steele]

The code in http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web" should be sufficient to point you in the right direction. (Note that it
also relies on http://www.mvps.org/access/api/api0001.htm)