Create application object for specific version of Access

  • Thread starter Thread starter bdtmike
  • Start date Start date
B

bdtmike

I have multiple versions of Access installed on my PC. For my
automation project is there a way to create an application object for
a specific version of Access?

In other words,

something like this:

dim o as object
set o= createobject("Access10.Application")

I know the above code doesn't work but you get what I'm trying to do...
 
While wondering if Access Applications really do have
different CLSIDs for different versions (I don't have anything
installed here), I found this article:
http://www.geocities.com/floydian_99/inv4.html

You can specify the version of Access by changing the
file extension from .mdb to .CLSID.

Of course I knew that you could define your own file
extension to specify a particular version of Access, but
this is already defined: CLSIDs are automatically defined
as file extensions.

(david)

"Well, as it turns out, you can create a file, and instead of putting a
normal file extension as we normally do, we can put the associated CLSID as
the file's extension. But what's more interesting, it's that the file will
automatically assume the properties of the associated file extension, and
the extensions itself will be invisible."
 
Back
Top