Nuno Oliveira said:
Hi,
I'm using Access 2003.
When I try to open a form in my database I get this message " The expression
On Open you entered as the event property setting produced the following
error: Error in loading DLL".
I suspect you have extra references in the MDB which exist on your
colleagues system but don't exist on your system.
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 2003 default references when the MDB is in A2000 format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
The Access 2003 default references when the MDB is in A2002/A2003
format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.5 Library
Database is stored in the office internal network and other colleagues still
open the database without any problems.
However this concerns me. Are you folks all sharing the same front
end MDB on the server? If so you run an increased risk of corruptions
as well as weird problems. I'd strongly suggest giving each person
their own copy of the front end.
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