[AccessD] Close current database

On 2 May 2003 at 7:29, Jeanine wrote:

> 
> I just can't get the darn thing to close itself and open another db.
> 

One way, of the top of my head would be:

Public Declare Function ShellExecute Lib "shell32.dll" Alias _
"ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, ByVal _
lpDirectory As String, ByVal nShowCmd As Long) As Long _

Sub OpenTheOtherOne()
	ShellExecute(0,"Open","C:\Full\Path\To\YourSecondApp.mdb"","","",1)
	DoCmd.Quit
End Sub


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.