References

[John]

Hi

I have my app in access 2000 and the office version I have is 10.0 (xp).
When I send my app to clients (who have office 9.0/2000) as mde, how does my
application work around the reference problems due to version number
differences?

Thanks

Regards

[Tom Wickerath]

Re: References

Hi John,

Your app. is currently in Access 2000 format running on Access 2002 on your PC as a
regular .MDB, right? In order to convert the app. to a .MDE file, I believe you will find
that you need to do one of two things:

1.) Convert the database to the 2002 format and then make the .MDE file. Unfortunately,
this will lock out your clients who are still working with Access 2000.

2.) Open your database on a PC that has Access 2000 installed. Then create the .MDE
file.

Incidentally, you must not have any compile errors in your code, or else the process of
attempting to create the .MDE file will fail.

Access seems to be able to reference the correct version of the Microsoft Access Object
Library (version 9.0 for 2000 and version 10.0 for 2002) on-the-fly, but Access 2002
cannot create an Access 2000 compatible .MDE file.

Tom
_______________ _______________ ___________

"John" <John@nospam.in fovis.co.uk> wrote in message
news:3f9fed03$0 $5655$cc9e4d1f@ news.dial.pipex .com...
Hi

I have my app in access 2000 and the office version I have is 10.0 (xp).
When I send my app to clients (who have office 9.0/2000) as mde, how does my
application work around the reference problems due to version number
differences?

Thanks

Regards

[John]

Re: References

Hi Tom

Thanks for that.

My app is in access 2000. I have both office 2000 & office xp installed. My
app uses word 10 & office 10 references (I can't seem to find version 9.0
references in the list). My client only has office 2000 and so when I send
him the mde (with word 10 & office 10 references) it gives error 'functions
is not available....'. In my case it is the ltrim & rtrim functions.

I need to find a way that my mde app somehow references word 9 & office 9
when it is with the client.

Thanks

Regards


"Tom Wickerath" <AOS168RemoveTh isSpamBlock@com cast.net> wrote in message
news:MK6dnRyptM yuaAKiRVn-sw@comcast.com. ..[color=blue]
> Hi John,
>
> Your app. is currently in Access 2000 format running on Access 2002 on[/color]
your PC as a[color=blue]
> regular .MDB, right? In order to convert the app. to a .MDE file, I[/color]
believe you will find[color=blue]
> that you need to do one of two things:
>
> 1.) Convert the database to the 2002 format and then make the .MDE file.[/color]
Unfortunately,[color=blue]
> this will lock out your clients who are still working with Access 2000.
>
> 2.) Open your database on a PC that has Access 2000 installed. Then[/color]
create the .MDE[color=blue]
> file.
>
> Incidentally, you must not have any compile errors in your code, or else[/color]
the process of[color=blue]
> attempting to create the .MDE file will fail.
>
> Access seems to be able to reference the correct version of the Microsoft[/color]
Access Object[color=blue]
> Library (version 9.0 for 2000 and version 10.0 for 2002) on-the-fly, but[/color]
Access 2002[color=blue]
> cannot create an Access 2000 compatible .MDE file.
>
> Tom
> _______________ _______________ ___________
>
> "John" <John@nospam.in fovis.co.uk> wrote in message
> news:3f9fed03$0 $5655$cc9e4d1f@ news.dial.pipex .com...
> Hi
>
> I have my app in access 2000 and the office version I have is 10.0 (xp).
> When I send my app to clients (who have office 9.0/2000) as mde, how does[/color]
my[color=blue]
> application work around the reference problems due to version number
> differences?
>
> Thanks
>
> Regards
>
>
>[/color]

[Douglas J. Steele]

Re: References

Try using Late Binding.

See what Tony Toews has at http://www.granite.ab.ca/access/latebinding.htm
for an overview.

--
Doug Steele, Microsoft Access MVP

http://I.Am/DougSteele

(No private e-mails, please)



"John" <John@nospam.in fovis.co.uk> wrote in message
news:3f9ffee6$0 $5646$cc9e4d1f@ news.dial.pipex .com...[color=blue]
> Hi Tom
>
> Thanks for that.
>
> My app is in access 2000. I have both office 2000 & office xp installed.[/color]
My[color=blue]
> app uses word 10 & office 10 references (I can't seem to find version 9.0
> references in the list). My client only has office 2000 and so when I send
> him the mde (with word 10 & office 10 references) it gives error[/color]
'functions[color=blue]
> is not available....'. In my case it is the ltrim & rtrim functions.
>
> I need to find a way that my mde app somehow references word 9 & office 9
> when it is with the client.
>
> Thanks
>
> Regards
>
>
> "Tom Wickerath" <AOS168RemoveTh isSpamBlock@com cast.net> wrote in message
> news:MK6dnRyptM yuaAKiRVn-sw@comcast.com. ..[color=green]
> > Hi John,
> >
> > Your app. is currently in Access 2000 format running on Access 2002 on[/color]
> your PC as a[color=green]
> > regular .MDB, right? In order to convert the app. to a .MDE file, I[/color]
> believe you will find[color=green]
> > that you need to do one of two things:
> >
> > 1.) Convert the database to the 2002 format and then make the .MDE[/color][/color]
file.[color=blue]
> Unfortunately,[color=green]
> > this will lock out your clients who are still working with Access 2000.
> >
> > 2.) Open your database on a PC that has Access 2000 installed. Then[/color]
> create the .MDE[color=green]
> > file.
> >
> > Incidentally, you must not have any compile errors in your code, or else[/color]
> the process of[color=green]
> > attempting to create the .MDE file will fail.
> >
> > Access seems to be able to reference the correct version of the[/color][/color]
Microsoft[color=blue]
> Access Object[color=green]
> > Library (version 9.0 for 2000 and version 10.0 for 2002) on-the-fly, but[/color]
> Access 2002[color=green]
> > cannot create an Access 2000 compatible .MDE file.
> >
> > Tom
> > _______________ _______________ ___________
> >
> > "John" <John@nospam.in fovis.co.uk> wrote in message
> > news:3f9fed03$0 $5655$cc9e4d1f@ news.dial.pipex .com...
> > Hi
> >
> > I have my app in access 2000 and the office version I have is 10.0 (xp).
> > When I send my app to clients (who have office 9.0/2000) as mde, how[/color][/color]
does[color=blue]
> my[color=green]
> > application work around the reference problems due to version number
> > differences?
> >
> > Thanks
> >
> > Regards
> >
> >
> >[/color]
>
>[/color]

[John]

Re: References

The problem I am getting is on office 10 reference. How can I do late
binding with office 9.0 reference? I am using toolbars & ltrim/rtrim
functions in my app.

Thanks

Regards


"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:4NXnb.5592 1$7B1.53596@new s04.bloor.is.ne t.cable.rogers. com...[color=blue]
> Try using Late Binding.
>
> See what Tony Toews has at http://www.granite.ab.ca/access/latebinding.htm
> for an overview.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
>
> "John" <John@nospam.in fovis.co.uk> wrote in message
> news:3f9ffee6$0 $5646$cc9e4d1f@ news.dial.pipex .com...[color=green]
> > Hi Tom
> >
> > Thanks for that.
> >
> > My app is in access 2000. I have both office 2000 & office xp installed.[/color]
> My[color=green]
> > app uses word 10 & office 10 references (I can't seem to find version[/color][/color]
9.0[color=blue][color=green]
> > references in the list). My client only has office 2000 and so when I[/color][/color]
send[color=blue][color=green]
> > him the mde (with word 10 & office 10 references) it gives error[/color]
> 'functions[color=green]
> > is not available....'. In my case it is the ltrim & rtrim functions.
> >
> > I need to find a way that my mde app somehow references word 9 & office[/color][/color]
9[color=blue][color=green]
> > when it is with the client.
> >
> > Thanks
> >
> > Regards
> >
> >
> > "Tom Wickerath" <AOS168RemoveTh isSpamBlock@com cast.net> wrote in message
> > news:MK6dnRyptM yuaAKiRVn-sw@comcast.com. ..[color=darkred]
> > > Hi John,
> > >
> > > Your app. is currently in Access 2000 format running on Access 2002 on[/color]
> > your PC as a[color=darkred]
> > > regular .MDB, right? In order to convert the app. to a .MDE file, I[/color]
> > believe you will find[color=darkred]
> > > that you need to do one of two things:
> > >
> > > 1.) Convert the database to the 2002 format and then make the .MDE[/color][/color]
> file.[color=green]
> > Unfortunately,[color=darkred]
> > > this will lock out your clients who are still working with Access[/color][/color][/color]
2000.[color=blue][color=green][color=darkred]
> > >
> > > 2.) Open your database on a PC that has Access 2000 installed. Then[/color]
> > create the .MDE[color=darkred]
> > > file.
> > >
> > > Incidentally, you must not have any compile errors in your code, or[/color][/color][/color]
else[color=blue][color=green]
> > the process of[color=darkred]
> > > attempting to create the .MDE file will fail.
> > >
> > > Access seems to be able to reference the correct version of the[/color][/color]
> Microsoft[color=green]
> > Access Object[color=darkred]
> > > Library (version 9.0 for 2000 and version 10.0 for 2002) on-the-fly,[/color][/color][/color]
but[color=blue][color=green]
> > Access 2002[color=darkred]
> > > cannot create an Access 2000 compatible .MDE file.
> > >
> > > Tom
> > > _______________ _______________ ___________
> > >
> > > "John" <John@nospam.in fovis.co.uk> wrote in message
> > > news:3f9fed03$0 $5655$cc9e4d1f@ news.dial.pipex .com...
> > > Hi
> > >
> > > I have my app in access 2000 and the office version I have is 10.0[/color][/color][/color]
(xp).[color=blue][color=green][color=darkred]
> > > When I send my app to clients (who have office 9.0/2000) as mde, how[/color][/color]
> does[color=green]
> > my[color=darkred]
> > > application work around the reference problems due to version number
> > > differences?
> > >
> > > Thanks
> > >
> > > Regards
> > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Douglas J. Steele]

Re: References

LTrim/RTrim comes from VBA, not the Office reference.

In theory, you would use

dim objOffice As Object

Set objOffice = GetObject("Offi ce.CommandBar")

to instantiate a late bound reference to the toolbars. That would pick up
whatever version of Office was present.

--
Doug Steele, Microsoft Access MVP

http://I.Am/DougSteele

(No private e-mails, please)



"John" <John@nospam.in fovis.co.uk> wrote in message
news:3fa05d4c$0 $231$cc9e4d1f@n ews.dial.pipex. com...[color=blue]
> The problem I am getting is on office 10 reference. How can I do late
> binding with office 9.0 reference? I am using toolbars & ltrim/rtrim
> functions in my app.
>
> Thanks
>
> Regards
>
>
> "Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
> news:4NXnb.5592 1$7B1.53596@new s04.bloor.is.ne t.cable.rogers. com...[color=green]
> > Try using Late Binding.
> >
> > See what Tony Toews has at[/color][/color]
http://www.granite.ab.ca/access/latebinding.htm[color=blue][color=green]
> > for an overview.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (No private e-mails, please)
> >
> >
> >
> > "John" <John@nospam.in fovis.co.uk> wrote in message
> > news:3f9ffee6$0 $5646$cc9e4d1f@ news.dial.pipex .com...[color=darkred]
> > > Hi Tom
> > >
> > > Thanks for that.
> > >
> > > My app is in access 2000. I have both office 2000 & office xp[/color][/color][/color]
installed.[color=blue][color=green]
> > My[color=darkred]
> > > app uses word 10 & office 10 references (I can't seem to find version[/color][/color]
> 9.0[color=green][color=darkred]
> > > references in the list). My client only has office 2000 and so when I[/color][/color]
> send[color=green][color=darkred]
> > > him the mde (with word 10 & office 10 references) it gives error[/color]
> > 'functions[color=darkred]
> > > is not available....'. In my case it is the ltrim & rtrim functions.
> > >
> > > I need to find a way that my mde app somehow references word 9 &[/color][/color][/color]
office[color=blue]
> 9[color=green][color=darkred]
> > > when it is with the client.
> > >
> > > Thanks
> > >
> > > Regards
> > >
> > >
> > > "Tom Wickerath" <AOS168RemoveTh isSpamBlock@com cast.net> wrote in[/color][/color][/color]
message[color=blue][color=green][color=darkred]
> > > news:MK6dnRyptM yuaAKiRVn-sw@comcast.com. ..
> > > > Hi John,
> > > >
> > > > Your app. is currently in Access 2000 format running on Access 2002[/color][/color][/color]
on[color=blue][color=green][color=darkred]
> > > your PC as a
> > > > regular .MDB, right? In order to convert the app. to a .MDE file, I
> > > believe you will find
> > > > that you need to do one of two things:
> > > >
> > > > 1.) Convert the database to the 2002 format and then make the .MDE[/color]
> > file.[color=darkred]
> > > Unfortunately,
> > > > this will lock out your clients who are still working with Access[/color][/color]
> 2000.[color=green][color=darkred]
> > > >
> > > > 2.) Open your database on a PC that has Access 2000 installed.[/color][/color][/color]
Then[color=blue][color=green][color=darkred]
> > > create the .MDE
> > > > file.
> > > >
> > > > Incidentally, you must not have any compile errors in your code, or[/color][/color]
> else[color=green][color=darkred]
> > > the process of
> > > > attempting to create the .MDE file will fail.
> > > >
> > > > Access seems to be able to reference the correct version of the[/color]
> > Microsoft[color=darkred]
> > > Access Object
> > > > Library (version 9.0 for 2000 and version 10.0 for 2002) on-the-fly,[/color][/color]
> but[color=green][color=darkred]
> > > Access 2002
> > > > cannot create an Access 2000 compatible .MDE file.
> > > >
> > > > Tom
> > > > _______________ _______________ ___________
> > > >
> > > > "John" <John@nospam.in fovis.co.uk> wrote in message
> > > > news:3f9fed03$0 $5655$cc9e4d1f@ news.dial.pipex .com...
> > > > Hi
> > > >
> > > > I have my app in access 2000 and the office version I have is 10.0[/color][/color]
> (xp).[color=green][color=darkred]
> > > > When I send my app to clients (who have office 9.0/2000) as mde, how[/color]
> > does[color=darkred]
> > > my
> > > > application work around the reference problems due to version number
> > > > differences?
> > > >
> > > > Thanks
> > > >
> > > > Regards
> > > >
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]