MDE

[Domino]

Can someone advise on the following:

Developing a database in Access 2002 in which I use references to Word and
Outlook 2002. If I convert the database to a MDE file how would my client,
who uses Word & Outllook 2000 be able to change the references for these
earlier versions?

TIA

domino

 

[Allen Browne]

Use late binding, i.e.:
Dim obj As Object
instead of declaring the specific kind of Word/Outlook object you need. The
reference gets resolved at runtime.

More info and examples:
http://support.microsoft.com/?id=210111

 

[Domino]

Allen

Would the late binding reference be set in the forms module or would it be
set as public in a seperate module

Thhanks in advance
domino

 

[Domino]

Allen

Would late bindings be set in the forms module or can they be set globally
in a seperate module

Thanks for your help

domino

 

[Allen Browne]

You reference the library as normal, through Tools | References.
Access sorts out the versioning when the database loads.

Then use the Object in any procedure that needs it. So long as you don't use
a specific type of object, Access is able to resolve the reference at
runtime using the appropriate library.

 

[Douglas J. Steele]

With Late Binding, you don't need to reference the library at all, Allen.
That's one of the reason for using Late Binding.

 

[Allen Browne]

Thanks Doug.