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?
Why does this dialogue box popup
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Why does this dialogue box popup
I assume you intended to upload a screenshot?
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: Why does this dialogue box popup
Sure did
You do not have the required permissions to view the files attached to this post.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Why does this dialogue box popup
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
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 5StarLounger
- Posts: 1148
- Joined: 08 Feb 2010, 21:27
Re: Why does this dialogue box popup
Thanks Rudi, references showed Utility which i didn't introduce, since removing it all is well.
-
- Administrator
- Posts: 78475
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Why does this dialogue box popup
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
Hans