Re: VB6 / switch versions of Access library reference.

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 08/06/04 

Date: Fri, 6 Aug 2004 18:32:05 -0400

You could use Late Binding. That way, you don't need to set a reference at
all.

Some people feel there's a performance hit with late binding, but I've never
found it to be that noticable. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"John D" <john.doss@comcast.net> wrote in message
news:6766b8dd.0408051843.58f23929@posting.google.com...
> Greetings,
> I have a VB6 app which gathers a custom property value from a local MS
> Access 2000 file. It compares the custom property value with the same
> custom property in a master MS Access 2000 file on a network. Until
> Access XP came along, this worked fine with those PC's running Access
> 2000. My VB app used the Microsoft Access 9.0 library to do the job,
> but when a PC using Access XP runs it, I don't get the same results.
> Shall I create a separate version of my app using the Microsoft Access
> 10 Library, and use it on those PC's running Access XP??? Is there a
> way to detect which version the user is using and dynamically switch
> to the respective library???
> I'm interested in using one version of my app rather than two merely
> for the challenge. However, two versions would be a quick fix.
>
> Thank you in advance.
> John

Relevant Pages

  • Re: VBA Error #429: ActiveX component cant create object
    ... I have a VBA procedure which sends an email. ... Late binding means you can safely remove the reference and only have ... an error when the app executes lines of code in question. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2000 Find Inbox at Runtime
    ... up the app and not allowing the users in the app at all. ... You'll want to install the reference if you are programming or debugging and want to ... remove the reference and setup the late binding statements. ... Binding in Microsoft Access" page at http://www.granite.ab.ca/access/latebinding.htm ...
    (microsoft.public.outlook.interop)
  • Re: Access 2000 Find Inbox at Runtime
    ... up the app and not allowing the users in the app at all. ... You'll want to install the reference if you are programming or debugging and want to ... remove the reference and setup the late binding statements. ... Binding in Microsoft Access" page at http://www.granite.ab.ca/access/latebinding.htm ...
    (microsoft.public.outlook.general)
  • Re: Access 2000 Find Inbox at Runtime
    ... up the app and not allowing the users in the app at all. ... You'll want to install the reference if you are programming or debugging and want to ... remove the reference and setup the late binding statements. ... Binding in Microsoft Access" page at http://www.granite.ab.ca/access/latebinding.htm ...
    (microsoft.public.outlook.program_vba)
  • VB6 / switch versions of Access library reference.
    ... I have a VB6 app which gathers a custom property value from a local MS ... this worked fine with those PC's running Access ... Shall I create a separate version of my app using the Microsoft Access ...
    (microsoft.public.vb.database)