By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

References

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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


Nov 12 '05 #4

P: n/a
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



Nov 12 '05 #5

P: n/a
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
>
>
>



Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.