Get Access path for shortcut to load Database

[roytheboy]

Hey Guys and Gals,

I need to develop an application that will be deployed all over the place and on numerous non-uniform platforms and I need to ensure my application can run with the usual

Path to Access /// Path to DB /// Path to security file.

Now the installation of office may differ depending upon what the user has entered as the installation path.

e.g. Maybe

c:\program files\microsoft office
c:\program files\microsoft office 2000
c:\program files\microsoft office 2003
c:\program files\msoffice
c:\program files\ms_office

and so on

How can i get my shortcuts to my application to extract the path where access is installed for the shortcut ..

e.g. $path\msaccess.exe /// db path // db security.

So I need to either extract the path for MSACCESS.exe or use another mehtod.. Either way can someone please feedback

Just to recap this is OUTSIDE of access to load the database not within access to load another database.

Thanks in advance.

Romolo.

 

[PaulBricker]

What about something like this

http://www.mvps.org/access/api/api0018.htm

Basically you pass the file name to the fHandleFile Function and if the extension is known (.mdb, .mde or whatever) it automatically opens the Parent application.

Paul

 

[roytheboy]

Thanks PaulBricker,

But I really dont want to use a loader (for want of a better description)

...

thanks for the help though...

still need an answer

Roy