Access 2000/2002 compatibility

[Zawy]

Hello to everybody in the NG.

I have a question: I have written an application in Access 2002; given that
all the PCs of my customer have Access 2000 installed, I saved the
application in Access 2002 format.

When I have brought my application on the customer's machines, I received
strange compilation errors.

I tryed everything possible (database conversions, compact database, etc.)
and I verified that there aren't library linking problems.

Could you suggest something to me?

Many thanks in advance, all the best.
Marco.

 

[Tony Toews]

I have a question: I have written an application in Access 2002; given that
all the PCs of my customer have Access 2000 installed, I saved the
application in Access 2002 format.

Presumably you meant you saved the MDB in A2000 format.

When I have brought my application on the customer's machines, I received
strange compilation errors.

What kind of errors? Are any of your references missing?

Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones, delete
from the references list and Compile and Save All. Keep any
necessary references and ensure they are distributed to the target
system.

For a very detailed page on reference problems see
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

The Access 97 default references are:
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.5x Object Library

The Access 2000 default references are:
Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
or
Microsoft DAO 3.6 Object Library

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm