Access Runtime or Full Version of Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to determine whether a workstation has the Full Version of Access 2003
or Access Runtime installed. When you manually uninstall Access Runtime, it
says it is successful, but leaves it in Add/Remove Programs, so I cannot use
Add Remove Programs in my SMS or SQL query. Is there a way to determine which
is installed?
Management needs this report and I am stumped as to how to determine whether
the full version of Access 2003 is installed or just Access Runtime.

Thanks,
 
William,

Thanks for your response. What I need is a way to create a query (SMS or
SQL) to identify whether a workstation has Access 2003 or Access Runtime
installed. Somehow I need to identify a software file (msaccess.exe is not an
option as it is identical for both installs) that might be installed with
Access 2003, but not Access Runtime OR installed with Access Runtime, but not
Access 2003.

I think the command you show in your reply has to do with which product
actually opens an Access database, not positive about this either. This will
not work for me in a SQL or SMS query.

Does anyone have any knowledge of differences in the two installs?

Thanks,
Sandy Martin
 
Sandy Martin said:
William,

Thanks for your response. What I need is a way to create a query (SMS or
SQL) to identify whether a workstation has Access 2003 or Access Runtime
installed. Somehow I need to identify a software file (msaccess.exe is not an
option as it is identical for both installs) that might be installed with
Access 2003, but not Access Runtime OR installed with Access Runtime, but not
Access 2003.

I think the command you show in your reply has to do with which product
actually opens an Access database, not positive about this either. This will
not work for me in a SQL or SMS query.

Does anyone have any knowledge of differences in the two installs?
Click to expand...

Just a thought, but you might try invoking a feature that is not available in
the runtime and see if you get an error. Most of the differences on the PC have
to do with registry entries. I'm not sure how much difference one would find in
the files.
 
Rick,

I found several Microsoft Office Access 2003 files (databases related to the
Access Tool Wizard) that are not installed with Microsoft Access 2003
Runtime. I am collecting file information (with SMS) on ACWZLIB.MDE which is
located in the c:\Program Files\Microsoft Office\Office11\ directory. The SMS
report only lists the workstation name if the file is present. I think this
will solve my problem.

Thanks for the replies,
Sandy Martin
 
Back
Top