Hello

I want to launch Access Database using any of the win32 api function. IS there any function which does?

I tried from VB using shell it is not launching and also i am not able to set the focus to the access window(which is already opened).

Any solution for this?

http://www.andreavb.com/forum/viewtopic.php?TopicID=856&page=0#2482

http://www.andreavb.com/forum/viewtopic.php?TopicID=559&page=0#1435

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

Hi,
Thanks for the links.

But i tried with the below one And it worked.

str = "C:\Program Files\Microsoft Office\Office\MSACCESS.exe"" ""C:\Program Files\ESCAPE Tool\ESCAPE Tool V3.2.3\ESCAPE_Tool.MDB"

str1 = Chr$(34) & str & Chr$(34)

notepadID = Shell(str1, vbNormalFocus)

And still i have one more issue, like iam not able get the handle of the form opened.

Actually, when i launch this MDB, it acts as an exe launch the initial form window.

But i am not able to get the handle of it. Is there any way i can get it?

You can get window handle by knowing its title:

Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Dim handle As Long     handle = FindWindow(vbNullString, "Untitled - Notepad")

This will retrieve the handle of the notepad.

____________________________
If you find the answer helpful, please mark this topic as solved.