Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems with Access

Status
Not open for further replies.

slycer

Technical User
Joined
Nov 22, 2002
Messages
84
Location
US
I have a database that opens fine on two computers, but on on another machine I get a "complier error" and then the visual basic script debugger opens. I tried re-loading MSOffice several times but to no avail. I was thinking maybe re-install SP6, but im not sure, have any of you had this problem, and how did you fix it?
 
Sounds more like a component that your version Access requires is not on this PC. Since you mentioned SP6 I'm guessing your talking about WinNT? What version of Access?

This is fairly easy to fix. Just not sure what action to tell you to take yet.

Craig
 
I am using MSOffice 2000.
 
Sounds like you might be missing a reference to a Dynamic Link Library on the offending machine. On a working machine, open a form in design view, then code view (View/Code). Open Tools/References and take a screen shot of the references listed there (Ctrl+PrintScreen). Take this to the nonworking machine and check to see if the all the references are in place. If not, check the box by the ones you need and click OK. You will need exclusive access to save the changes.
 
Forgot to say after you take the screen shot, you need to paste it in another program (Word will do) so you can see and/or print it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top