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]

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" <Jo**@nospam.infovis.co.uk> wrote in message
news:3f**********************@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]

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" <AO***********************@comcast.net> wrote in message
news:MK********************@comcast.com...

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" <Jo**@nospam.infovis.co.uk> wrote in message
news:3f**********************@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

[Douglas J. Steele]

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" <Jo**@nospam.infovis.co.uk> wrote in message
news:3f**********************@news.dial.pipex.com. ..

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" <AO***********************@comcast.net> wrote in message
news:MK********************@comcast.com...

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" <Jo**@nospam.infovis.co.uk> wrote in message
news:3f**********************@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]

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_djsteele@NOSPAM_canada.com> wrote in message
news:4N*******************@news04.bloor.is.net.cab le.rogers.com...

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" <Jo**@nospam.infovis.co.uk> wrote in message
news:3f**********************@news.dial.pipex.com. ..

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" <AO***********************@comcast.net> wrote in message
news:MK********************@comcast.com...

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" <Jo**@nospam.infovis.co.uk> wrote in message
news:3f**********************@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

[Douglas J. Steele]

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

In theory, you would use

dim objOffice As Object

Set objOffice = GetObject("Office.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" <Jo**@nospam.infovis.co.uk> wrote in message
news:3f*********************@news.dial.pipex.com.. .

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_djsteele@NOSPAM_canada.com> wrote in message
news:4N*******************@news04.bloor.is.net.cab le.rogers.com...

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" <Jo**@nospam.infovis.co.uk> wrote in message
news:3f**********************@news.dial.pipex.com. ..

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" <AO***********************@comcast.net> wrote in

message news:MK********************@comcast.com...
> 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" <Jo**@nospam.infovis.co.uk> wrote in message
> news:3f**********************@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
>
>
>