"RWC" <he*************************@shaw.ca> wrote:
I'm getting an odd error in my Package and deployment wizard that seems to
have cropped up for no good reason. The erros is as follows;
Error -2147221163 Method '~' of Object '~' failed.
Any ideas? I'm running service pack 2. This happens when it's trying to
scan the program database.
I'm guessing you have a strange, likely unwanted reference.
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....nceErrors.html
Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.
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
The Access 2002 default references when the MDB is created in Access
2000 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
The Access 2002 default references when the MDB is created in Access
2002 format are:
Visual Basic for Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.5 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