Access version using CreateObject

[auditor.software]

Hi.
I need to run a function from another database, using:
Dim App as Access.Application
Set App = CreateObject("C:\LibDB.mde")
App.Run "MyFunc", ...
I use Access2K database format, and I install Access Runtime 2000 or
2002 to the users, along with my application.
The problem can arise when a user already has another Access version
installed on his computer, say Access97. In that case, CreateObject
may attempt to start Access97 and, since the database format is 2000,
will fail.
I've seen some workarounds to this problem, all of them are not very
elegant.
Any help will be appreciated.

[Tony Toews [MVP]]

au**************@gmail.com wrote:

>I need to run a function from another database, using:
Dim App as Access.Application
Set App = CreateObject("C:\LibDB.mde")
App.Run "MyFunc", ...

I haven't found a solution to this problem. But I haven't look very hard either.

>I've seen some workarounds to this problem, all of them are not very
elegant.

What work arounds did you find?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[auditor.software]

On Aug 6, 9:15 pm, "Tony Toews [MVP]" <[e-mail]:

[e-mail] wrote:

I need to run a function from another database, using:
Dim App as Access.Application
Set App = CreateObject("C:\LibDB.mde")
App.Run "MyFunc", ...

I haven't found a solution to this problem. But I haven't look very hard either.

I've seen some workarounds to this problem, all of them are not very
elegant.

What work arounds did you find?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

I found the workaround here:
http://www.everythingaccess.com/tuto...OLE-automation
However, the solution there doesn't seem to be 100% robust , as
explained here:
http://support.microsoft.com/kb/q238610/