Re: Manual opening of files .mdb

From: PC Data*** (spam_at_nospam.spam)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 18:46:58 GMT

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

--
                                         PC Data***
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdata***.com
                                 www.pcdata***.com
"G. E." <dsddi@fjas.com> wrote in message news:40571825$1@proxy....
> 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.
>
>