opening another .mdb file within access 
Author Message
 opening another .mdb file within access

I've got a problem opening an access database from within access ('97). When
I execute next funtion :
shell "msaccess \\Hwpsrv1\BR2-Expl\TOEPI\SO\S040\S040.mdb".
access opens again ( that's good) but an error occurs (contains an option
that ms Access doesn't recognize). Is there another way to open an access
database from within access ??


Fri, 27 Sep 2002 03:00:00 GMT  
 opening another .mdb file within access
The easiest way IMO is to use the ShellExecute API. With Shell, you have to
pass the full exepath (Syscmd(acSysCmdAccessDir) & "MSAccess.exe"). Also try
wrapping the filename in quotes.

 -- Dev

:I've got a problem opening an access database from within access ('97).
When
:I execute next funtion :
:shell "msaccess \\Hwpsrv1\BR2-Expl\TOEPI\SO\S040\S040.mdb".
:access opens again ( that's good) but an error occurs (contains an option
:that ms Access doesn't recognize). Is there another way to open an access
:database from within access ??
:
:
:



Fri, 27 Sep 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Specifiying a Workgroup File When Using ADO to Open an Access .mdb file (OLEDB)

2. Opening Access 97 mdb file with Windows 2000

3. Microsoft Jet Database Engine Cannot Open The File.......(access)mdb

4. 'how to open an password protected access mdb file

5. 'how to open an password protected access mdb file

6. 'how to open an password protected access mdb file

7. 'how to open an password protected access mdb file

8. Microsoft Jet Database Engine Cannot Open The File.......(access)mdb

9. Opening a connection with ADO to a MS Access 97 .mdb file

10. Opening an .mdb file from VB into Access

11. Opening an .mdb file from VB into Access

12. Can I open a specific Excel file from within Access

 

 
Powered by phpBB® Forum Software