• Status: Solved
• Priority: Medium
• Security: Public
• Views: 612

# Shell execute API vb.net Launch a program

Does an anyone know if it is possible to run an Access database without specifying the location of MCAccess.exe if so what is the syntax?

(My users have MSAccess.exe in various places) I thought of putting the location of the exe in a text file on the client but this is a bit clumsy.
0
HKFuey
• 2
2 Solutions

Commented:
This should point you in the right direction:
http://support.microsoft.com/kb/317113

Dim oAccess As Access.Application

' Start a new instance of Access for Automation:
oAccess = New Access.ApplicationClass()

' Open a database in exclusive mode:
oAccess.OpenCurrentDatabase(filepath:="c:\mydb.mdb", Exclusive:=True)
0

Commented:
If the user has the corresponding Access database files registered to open with Access (by default they would), then you can simply specify the database filename to Process.Start. If the user has changed the default application for such files, then they will opened using that program.

e.g.

System.Diagnostics.Process.Start("C:\path\to\database\file.accdb")

0

Author Commented:
Thanks, will try after the weekend! ; )
0

Author Commented:
Works great, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.