Access version in CreateObject

[dima69]

Hi all.
I use a following code to run a procedure in another application:

Dim App as Access.Application
set App = CreateObject("C:\MyApp.mde")
App.Run "MyProc"
...

The problem is that when using CreateObject I cannot determine which version of Access will be started for App.
So if my main application supports Access2K2, and the user has Access2K installed (in addition to Access2K2), CreateObject may return Access2K application - even if calling application is running on Access2K2.

So the question is how to get the Application object of the desired Access version ?

[ADezii]

Hi all.
I use a following code to run a procedure in another application:

Dim App as Access.Application
set App = CreateObject("C:\MyApp.mde")
App.Run "MyProc"
...

The problem is that when using CreateObject I cannot determine which version of Access will be started for App.
So if my main application supports Access2K2, and the user has Access2K installed (in addition to Access2K2), CreateObject may return Access2K application - even if calling application is running on Access2K2.

So the question is how to get the Application object of the desired Access version ?

1. Your syntax for the CreateObject() Function will not work in its current context. The correct Procedure is:
   

   CreateObject(class, [servername])
    
   Dim xlApp As Excel.Application 
   Set xlApp = CreateObject("Excel.Application")

2. The specific Version is not required in the class Argument, but if you so desire, you can determine the Version by querying the Version Property of the Application Object as in:
   

   Application.Version

[dima69]

1. Your syntax for the CreateObject() Function will not work in its current context. The correct Procedure is:
   

   CreateObject(class, [servername])
    
   Dim xlApp As Excel.Application 
   Set xlApp = CreateObject("Excel.Application")

2. The specific Version is not required in the class Argument, but if you so desire, you can determine the Version by querying the Version Property of the Application Object as in:
   

   Application.Version

1. The syntax is correct. It's the alternative syntax. Moreover, It's the only one that will work in case you create Access Runtime application object (ART cannot create object without database)
2. Querying the version doesn't really help to solve the problem, if the version is not the one I need :)

[ADezii]

1. The syntax is correct. It's the alternative syntax. Moreover, It's the only one that will work in case you create Access Runtime application object (ART cannot create object without database)
2. Querying the version doesn't really help to solve the problem, if the version is not the one I need :)

I apologize for the misinformation - I was not aware of the alternative syntax as it relates to the Access Runtime Application Object. Thanks for the info.