Hello,
I'm reposting in this newsgroup at user suggestion in vb newsgroup.
What responder to my message is indicating is that I can loop through
references collection in VB to reset the reference to the different Access
type library version present on the user's PC?
Thanks for any suggestions,
Jim M.
> Hi,
>
> VB6
> I'm building Jet database tables. Then I'm calling msAccess to open a
> pre-existing re****t. Problem is that users are experiencing
> the errors relating to invalid references. In this case the error is
> "Undefined function 'trim' in expression."
>
> The root cause is actually within the jet database which has a missing
> reference to the version of the access type library that
> I'm using on the developer machine. This wouldn't be happening if I
> weren't calling vba code from within the re****t, but I am.
> If the user has a different version of the msOffice/Access installed,
the
> error is raised.
>
> Is there a programmatic workaround? Before calling the re****t open
> command from VB6 can I redirect the reference to the version
> installed on the PC of the user attempting to run the re****t?
>
The Access object library has a Reference object and a References
collection
you can use to change references. I used to have code
that would "reset" references, but that was a number of years ago when I
worked for a company that used Access a lot. In any case,
you'd probably get better luck with this if you ask in an Access newsgroup
because it really doesn't have anything to do with your
VB6 app.
--
Mike
Microsoft Visual Basic MVP
|
