References broken when emailing *.mdb/*.zip

  • Thread starter Thread starter EKC
  • Start date Start date
E

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.
 
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.
 
Back
Top