opening a access db while in anouther db 
Author Message
 opening a access db while in anouther db

I need to shut down "access db1" and open "access db2"
all from the first db. im having no luck woth
opendatabase.

gary k



Wed, 08 Jun 2005 04:44:58 GMT  
 opening a access db while in anouther db
Hi,

Consider the following example:

Dim lRetVal As Long
lRetVal = Shell("msaccess.exe C:\TheOtherFile.mdb")
Application.Quit

--
Calvin Smith - http://www.CalvinSmithSoftware.com

Code Newsletter - http://www.CalvinSmithSoftware.com/newsletter.htm
VB/VBA Tools - http://www.CalvinSmithSoftware.com/GreatDeals.htm
Turnkey Site - http://www.CalvinSmithSoftware.com/ecommerce1.htm


Quote:
> I need to shut down "access db1" and open "access db2"
> all from the first db. im having no luck woth
> opendatabase.

> gary k



Wed, 08 Jun 2005 05:06:44 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Can set a ref to 1 open db but not another open db - error 3045

2. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

3. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

4. Convert Access 97 db to Access 2000 db in VB6

5. Attaching Access Db files to Access DB

6. Converting Access 2.0 DB to Access 97 DB in VB code

7. Opening a DB from within a DB

8. Mail merge from Access try to open an already open DB

9. INSERT INTO Access DB from SQL DB-HELP!!

10. accessing records in one secure DB from another secure DB - programatically

11. Working with protected Access DB and non-protected DB in the same application

12. Create a db access db with password

 

 
Powered by phpBB® Forum Software