how to open another access database

[nurul]

hye all...



i want to ask is there any way to open another access database using when click button at form..
for example i have tracking.accb then at my switchboard form, i would like to have a button that can go to another access which is borrow.accb.

can these possible for me to do it..?
any help much appreciate..

thank in advance

[June7]

Google: VBA open Access file
http://www.pcreview.co.uk/forums/wha...-t3889030.html

Example:

'following will now open the Access file
Set oShell = CreateObject("WScript.Shell")
oShell.Run """C:\Program Files\Microsoft Office\Office12\msaccess.exe"" ""c:\MaterialsDatabase.accdb"""

[nurul]

thank June7 for reply..

that meant i need to paste this code into the module right..

Option Compare Database
Option Explicit

Private Declare Function apiShellExecute _
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


Public Function ShellEx(FileName As String) As Boolean
ShellEx = Iif( _
apiShellExecute(0, "open", FileName, vbNullString, vbNullString, 1), _
> 32, True, False
End Function

but then, where i need to paste your code?
following will now open the Access file
Set oShell = CreateObject("WScript.Shell")
oShell.Run """C:\Program Files\Microsoft Office\Office12\msaccess.exe"" ""c:\MaterialsDatabase.accdb"""

thank in advance.

[June7]

The sample code I provided does NOT need the apiShellExecute code. Those are two different methods to achieve the same end. The hyperlink method is a third.

My example code can go in any procedure you want and is an example for the second method alluded to in the referenced link.

[nurul]

owh yeah..

thank you June7..it work great now..