utility.mda Access 2007 (Win XP Access 2007)

Topic

New Reply

have an application that runs fine under Access 2003 but when I move the application to Access 2007 as an .mdb I have problems with a reference. The app looks for utility.mda, which does not exist. I re-installed the Access 2007, but the problem persists.
Under Access 2003 the references include a

Reply | Quote

Replies

Do you really need the reference to utility.mda? What happens if you remove the reference?

Reply | Quote

I get an error message about the missing reference. After I close the message, the application loads normally. Then, when I attempt to add “on the fly” a new entry for a combo box, I get an error in the VBA window. All of this has worked for years, so I suppose that the utility.mda is necessary.

Reply | Quote

The prior note was with the reference marked as “missing” When I remove the check mark requiring the reference, the application seems to work OK!!! Your thoughts?

Reply | Quote

In general, Access applications don’t need a reference to Utility.mda. So I’d leave the reference to Utility.mda unchecked. To make sure, select Debug | Compile to see if the code compiles correctly.

Reply | Quote

It looks like no problems. I guess I just carry on with the fingers crossed, as they say. Thanks, as usual.

Reply | Quote

If Debug | Compile didn’t result in an error message, you shouldn’t have anything to worry about (in this respect).

Reply | Quote