ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calling a specific version of Access. (https://www.excelbanter.com/excel-programming/332053-calling-specific-version-access.html)

Derek Anderson

Calling a specific version of Access.
 
Is there any way to specify the version of access we would like to call via
the Access.Application. My company uses both 97, and 2003 right now, due to
upgrade delays. As such many PCs need both, and well 97 dosn't like to do
everything 2003 does :). Does anyone know if there is a way to specify?
Thanks.

Nigel

Calling a specific version of Access.
 
AFAIK you cannot. The current version will be loaded, however in the
application you can determine the version and the opsys using the following
and then take appropriate action. My advice would be write code for the
lowest common denominator (oldest version) until the transisition is
complete.

Application.Version
Application.OperatingSystem

--
Cheers
Nigel



"Derek Anderson" <Derek wrote in message
...
Is there any way to specify the version of access we would like to call

via
the Access.Application. My company uses both 97, and 2003 right now, due

to
upgrade delays. As such many PCs need both, and well 97 dosn't like to do
everything 2003 does :). Does anyone know if there is a way to specify?
Thanks.




Derek Michael

Calling a specific version of Access.
 
Thank you for your quick response.

"Nigel" wrote:

AFAIK you cannot. The current version will be loaded, however in the
application you can determine the version and the opsys using the following
and then take appropriate action. My advice would be write code for the
lowest common denominator (oldest version) until the transisition is
complete.

Application.Version
Application.OperatingSystem

--
Cheers
Nigel



"Derek Anderson" <Derek wrote in message
...
Is there any way to specify the version of access we would like to call

via
the Access.Application. My company uses both 97, and 2003 right now, due

to
upgrade delays. As such many PCs need both, and well 97 dosn't like to do
everything 2003 does :). Does anyone know if there is a way to specify?
Thanks.






All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com