PC Review


Reply
Thread Tools Rate Thread

Create application object for specific version of Access

 
 
bdtmike
Guest
Posts: n/a
 
      30th May 2007
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...

 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      30th May 2007
Try:

set o= createobject("Access.Application.10")

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"bdtmike" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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...
>



 
Reply With Quote
 
Guest
Posts: n/a
 
      30th May 2007
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."



"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:e3u%(E-Mail Removed)...
> Try:
>
> set o= createobject("Access.Application.10")
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "bdtmike" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >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...
> >

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Targeting application for a specific version Raj Microsoft C# .NET 1 18th Sep 2009 04:55 PM
Need to create a .NET object that will be serialized into a specific XML format Gasnic Microsoft Dot NET 2 31st Jan 2007 09:16 AM
How to force VBA to create an Excel.Application object of specified version of Excel? surotkin Microsoft Excel Programming 0 1st Nov 2005 07:32 PM
ActiveX component can't create object: Access.Application =?Utf-8?B?bWJfaG93YXJk?= Microsoft Access Macros 0 26th Oct 2004 05:31 PM
Late Bind to Specific version of Application jason Microsoft Excel Programming 5 26th Jun 2004 03:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:04 PM.