Software

Ask something
Discussion Locked

ACCESS'97/VISUAL BASIC ERROR

0 helpful
3 replies

by mozster

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm using Access'97 under Windows 98 and whenever I open up one of the companys databases that involves any type of switchboard at the start or visual basic code it gives me a "compile error" and dumps me in the debugger screen.

These databases open up fine on other users PC's who are using the same versions of Windows and Access.
I've tried running the Office'97 service packs up to level 2 but the problem is still there.
Could it be anything to do with the version of visual basic libraries installed?

Any help is appreciated.

Martin

3 replies

by steve mac

The first thing you need to determine is what function it is having a problem compiling. If it is a standard VBA function or keyword, you are probably right about the VBA versioning problem. I would try looking at the references and make sure none of them are 'broken' on that system. The easiest way to do this, is to bypass the startup code on the database (hold down the shift key when opening the database), opening any module, then selecting Tools, References. The first indication of trouble is if any of the checked references starts with '(Missing)'. If this is the case, check where it is looking for the dll, and then try finding it on the system. Don't change the reference on this system, otherwise it will break it for all other systems. What you'll need to do is get the missing dll moved to the correct location and then re-register it using regsvr32.exe. Good luck and feel free to contact me if you need any further help with this.

This discussion is closed to new replies.