Why does this dialogue box popup

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Why does this dialogue box popup

Post by Pat »

This box pops up when I go to close an Access 2007 database, I notice it uses Office11 as part of it's folder??

How do I stop this?

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Why does this dialogue box popup

Post by Rudi »

I assume you intended to upload a screenshot?
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Why does this dialogue box popup

Post by Pat »

Sure did
You do not have the required permissions to view the files attached to this post.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Why does this dialogue box popup

Post by Rudi »

It seems likely that your database has a reference to an unnecessary VBA reference. You could resolve this by deselecting any unnecessary references from the VBA library.

Typically a database would reference the following libraries:
Visual Basic for Applications
Microsoft Access x.0 object library
OLE Automation
Microsoft ActiveX Data Objects

Check the references and deactivate ones that you are not sure should be ticked...(esp. those marked MISSING)
1. Open the database.
2. Press ALT+F11 to start Visual Basic Editor.
3. On the Tools menu, click References.
4. Under Available References, click to clear the check box next to the name of the library, and then click OK.

Additional links about this issue:
-- Missing utility.mda when trying to run an Access 2003 created db in Access 2007
-- http://allenbrowne.com/ser-38.html
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Why does this dialogue box popup

Post by Pat »

Thanks Rudi, references showed Utility which i didn't introduce, since removing it all is well.

User avatar
HansV
Administrator
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Why does this dialogue box popup

Post by HansV »

Utility.mda contains several of the Wizards for Access 2003 and before. If one of those wizards was used, a reference is created, although it isn't needed later on.
Best wishes,
Hans