469,658 Members | 1,862 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

Access version using CreateObject

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.

Aug 1 '07 #1
2 2425
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/
Aug 6 '07 #2
On Aug 6, 9:15 pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:
auditor.softw...@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 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/

Aug 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jason Burr | last post: by
2 posts views Thread by Aharon Koss | last post: by
reply views Thread by dkurtz | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.