Manual opening of files .mdb

[G. E.]

Hi all.
I have a problem I hope anyone have a answer on;
Background:
C:\Database\App.mdb = the "front end"
C:\Database\Data\Data1 = the "back end"

The problem is somehow little bit difficult for me to explain, but here we
go:
I am opening the back end mdb with the command:
DoCmd.TransferDatabase acLink ..... ,"C.\Database\data\data1.mdb".....

But I need to let this App reach out to another "data1.mdb" on other drives
or trhough network.
So, what I want is to use is a stringvariable instead of the
"C:\database\data\data1.mdb". But (and here comes the problem...) how do I
make a command in my App form that do the following job:
- Opens a file find dialog (eg. File -> Open).
- When File and Path are selected(NOT opens a file!), store the complete
path to the data1.mdb in a textstring variable. The value in this variable
will be used to the Link command above, and stored in the user table in tha
app.mdb as "last opened datafile".

A solution on this problem, will alse make the next step in my app possible;
the user hav to be able to swith betweens separate projects, and the user
want to separate each projects in separate "data1.mdb" files.

Is this a "asking for the moon" or is it possible to make?

Please excuse my terrible english writing!

Regards.

 

[PC Datasheet]

Go to www.mvps.org/access. Look at the first example code in the API section. It
does just what you are asking for.