Close one Database while openning another

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Last question was so helpful. Here is another that I have
not been able to solve and left as is for lack of
knowledge.

I have a form that is called utility. We have several
master mdb files that get used as templates for several
jobs. The utility copies the requested template(mdb file)
to a given job directory to a new provided name (name and
path are requested on the form in utitlity.mdb). The
problem is the person has to close the utility.mdb and
then locate the job directory and open the new mdb file.

Is there a procedure that would close the utility.mdb and
open the new mdb using the path and file name provided on
form in the utility.mdb?

Thanks...
 
Thought I tried this a few years ago. Maybe 2002 works
better than older versions as this time it worked with the
quit. I think in 95 you could not quit while in the vb
code if you openned another database...
Is this the proper way however???????
Dim MyAppID, ReturnValue
'open the new file
'MyAppID = Shell("C:\Program Files\Microsoft
Office\Office10\msaccess.exe Y:\Jobs\2005Jobs\205017
\NCmodel\NC-test3.mdb", 1)
Docmd.Quit
 
Last question was so helpful. Here is another that I have
not been able to solve and left as is for lack of
knowledge.

I have a form that is called utility. We have several
master mdb files that get used as templates for several
jobs. The utility copies the requested template(mdb file)
to a given job directory to a new provided name (name and
path are requested on the form in utitlity.mdb). The
problem is the person has to close the utility.mdb and
then locate the job directory and open the new mdb file.

Is there a procedure that would close the utility.mdb and
open the new mdb using the path and file name provided on
form in the utility.mdb?

Thanks...
Click to expand...

Shell Environ("comspec") & " /c " &chr(34) &"newDbPatrhName" &chr(34)
Application.Quit
 
Back
Top