References broken when emailing *.mdb/*.zip

[EKC]

I email my *.mdb (zipped) to people.
They open it up. Run it, and quickly get errors usually
"Type Mismatch". I have them open a module, check
references and find that one of the references
is either not there, or has moved position.
The refereces I use, in order, are

'Visual Basic for Applications
'Microsoft Access 9.0 Object Library
'Microsoft DAO 3.6 Object Library
'OLE Automation
'Microsoft ActiveX Data Objects 2.1 Library

I have seen over, and over, that the DAO 3.6 gets put at
the bottom for some reason.

How can I ensure this does not happen again? Im tired of
my customers complaining about something I dont seem to
have control over.

 

[Paul Overway]

If you are not actually using the ADO reference, you can remove. Otherwise,
you need to disambiguate all of your DAO references, i.e., Dim db as
DAO.Database.