How can I use VBA to determine where MSACCESS.exe is stored?

's Computer Specifications

I would to find out how to do this under program control. This way, once the
location is determined, I can create commands that can use MSACCESS from the
command line. Any help of sample code would be appreciated.

's Computer Specifications

Syscmd(acSysCmdAccessDir)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ken Higgins" <(E-Mail Removed)> wrote in message
news:A61887C0-DBDE-4A6C-8180-(E-Mail Removed)...
> I would to find out how to do this under program control. This way, once
the
> location is determined, I can create commands that can use MSACCESS from
the
> command line. Any help of sample code would be appreciated.

's Computer Specifications

Dig it out of the registry but be aware that you or your eventual
users may have more than one version of Access installed and therefore
registered.

David Aylott flogs a nifty utility named ACCVER that checks the
version of the target MDB/MDE and launches the correct version of
MSACCESS.EXE. It passes command line parameters to the executable.

HTH
--
-Larry-
--

"Ken Higgins" <(E-Mail Removed)> wrote in message
news:A61887C0-DBDE-4A6C-8180-(E-Mail Removed)...
> I would to find out how to do this under program control. This way,
once the
> location is determined, I can create commands that can use MSACCESS
from the
> command line. Any help of sample code would be appreciated.

's Computer Specifications

You might also look at
http://www.openaccess.co.za/BlackAnd...cessOpener.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Larry Daugherty" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Dig it out of the registry but be aware that you or your eventual
> users may have more than one version of Access installed and therefore
> registered.
>
> David Aylott flogs a nifty utility named ACCVER that checks the
> version of the target MDB/MDE and launches the correct version of
> MSACCESS.EXE. It passes command line parameters to the executable.
>
> HTH
> --
> -Larry-
> --
>
> "Ken Higgins" <(E-Mail Removed)> wrote in message
> news:A61887C0-DBDE-4A6C-8180-(E-Mail Removed)...
>> I would to find out how to do this under program control. This way,
> once the
>> location is determined, I can create commands that can use MSACCESS
> from the
>> command line. Any help of sample code would be appreciated.
>
>

's Computer Specifications

Thanks Doug - I'll take a look at the other reference you gave in a
subsequent post.
This is a nice simple solution and I like those !

Regards,
Ken

"Douglas J Steele" wrote:

> Syscmd(acSysCmdAccessDir)
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Ken Higgins" <(E-Mail Removed)> wrote in message
> news:A61887C0-DBDE-4A6C-8180-(E-Mail Removed)...
> > I would to find out how to do this under program control. This way, once
> the
> > location is determined, I can create commands that can use MSACCESS from
> the
> > command line. Any help of sample code would be appreciated.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"The provider could not determine the Object value" when accessing MSAccess database with ASP.NETV1	Siegfried Heintze	Microsoft ASP .NET	0	11th Nov 2005 05:55 AM
SQL Stored Procedures Criteria Reference to msAccess adp Form	Olivier	Microsoft Access ADP SQL Server	1	5th Aug 2005 07:40 AM
RE: Can Stored Procedures be made in MsAccess	=?Utf-8?B?QXJ1biBDaG9wcmE=?=	Microsoft Dot NET	0	8th Sep 2004 04:01 AM
Ho do I call Sqlserver stored procedures from MSAccess?	=?Utf-8?B?amVzc2ll?=	Microsoft Access VBA Modules	1	30th Aug 2004 07:36 AM
dataadapter insert command MSAccess 97 stored procedure - data truncated	NancyASAP	Microsoft ADO .NET	2	13th Apr 2004 07:03 PM