Question

Q: Access Documentor gives error "Application-defined or Object-defined error"

When I use the Database Documenter in a Microsoft Access database, I get the error  "Application-defined or Object-defined error."

I have no open objects.

Also, I have both databases on my desktop machine, and I am owner of all files, so there is no permission problem.

I'm using Access 2010, trying to document the front end database when the database is split between a front and back end.

Other online resources report similar problems with solutions that do not apply to me:

An object is open in a window, or the relationships window is open (from Microsoft Knowledge Base):
http://support.microsoft.com/default...b;en-us;207782

An object is open in a window (from Microsoft Knowledge Base):
http://support.microsoft.com/default...b;en-us;166290

Another user has an object checked out (I am the only user of this database on my hard drive) (from Microsoft Knowledge Base):
http://support.microsoft.com/default...b;en-us;169279


Also, here is a posting on a forum which describes students in a multi-user environment getting the error. It was fixed when they all god administrator privileges. This is also not applicable to me because I am owner of all the database files and it exists solely on my hard drive.
http://thedailyreviewer.com/office/v...2000-101786042



I would see if the database compiles. Also check to see if any form, report or query is using a table that no longer exists.
Bill Mosca
http://www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals
Bill Mosca
ThatllDoIT.com

Did this solve your problem?

Sorry this didn't help.


I would see if the database compiles. Also check to see if any form, report or query is using a table that no longer exists.
Bill Mosca
http://www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals
Thanks, Bill, for your response. Sorry about the late follow-up. I am not receiving alert e-mail messages (I don't know why).

The database does compile. There might very well be forms, reports, or queries that use non-existent tables. I inherited this application, and it has hundreds of queries, forms, and reports. Is there any way for me to find out without manually looking at every query, at every event and data source in every form, and at any place that might be using a table in the reports?

Did this solve your problem?

Sorry this didn't help.


You might try running a DECOMPILE

http://www.granite.ab.ca/access/decompile.htm

on it first and then try compiling again and see if that helps.  If it is fairly old and hasn't ever been decompiled it could probably use it.  But save a copy as a backup BEFORE doing anything to it.


Bob Larson, Former Access MVP (2008-2010) http://www.btabdevelopment.com (free Access tools, tutorials, and samples)
-----
Microsoft Access MVP 2008, 2009, 2011
If a post was helpful click the FOUND THIS HELPFUL link

Did this solve your problem?

Sorry this didn't help.


Thanks, Bob. I'll try that.

Did this solve your problem?

Sorry this didn't help.


Bob, I tried the decompile, compress, recompile, compress. It did reduce the size of the FE DB by about 30%, but I still get the "Application-defined or Object-defined error" message when I run documentor.

Did this solve your problem?

Sorry this didn't help.


Bob, I tried the decompile, compress, recompile, compress. It did reduce the size of the FE DB by about 30%, but I still get the "Application-defined or Object-defined error" message when I run documentor.


Well, I'm about out of ideas short of getting a copy of the database and being able to search through it myself.  At this point I don't know any other things to try except -

What if you import everything into a blank, database shell and see what happens then.


Bob Larson, Former Access MVP (2008-2010) http://www.btabdevelopment.com (free Access tools, tutorials, and samples)
-----
Microsoft Access MVP 2008, 2009, 2011
If a post was helpful click the FOUND THIS HELPFUL link

Did this solve your problem?

Sorry this didn't help.


Bob, I tried the decompile, compress, recompile, compress. It did reduce the size of the FE DB by about 30%, but I still get the "Application-defined or Object-defined error" message when I run documentor.


I think I found the problem with the documenter.  It is
choking on the ActiveX controls you are using, which frankly doesn’t surprise
me.  For many, many years now I have avoided using ActiveX controls,
unless I can’t get the functionality I need any other way, because they just
cause more problems than they are worth.  There is usually a workaround
for them so you don’t need them.  Not all of them have things that you can
use besides them but you are at the mercy of versions if you do use some (like
the Windows Media control and the IE Web Browser).



So, some alternatives which you can use:

For the Rich Text control:You can use Rich Text in 2007 or above by simply using a normal
text box and setting the field in the table to MEMO and then changing the
control’s TEXT FORMAT, located on the DATA tab within the Properties dialog, to
Rich Text from Plain Text.

For the CommonDialog:

You can use the built-in File Scripting Object (just need to set
a reference to Windows Scripting Host) or the Office File Dialog which you can
call if you have the Microsoft Office 14 Object Library checked.  And last
you can use this API here: http://www.mvps.org/access/api/api0001.htm


For the Calendar Control:

The MSCal.7 doesn’t exist in 2010 and is not available for use
there (it has been deprecated). 

You can use something like this: http://www.mvps.org/access/forms/frm0050.htm

 

Not sure what to suggest for the TreeView control or if there is
an alternative to the IE browser or Windows Media controls.  They might
not give you a problem if they are installed on your machine (the versions you
have used).  They gave me a problem but I’m running IE9 and Windows Media
11.



As for the navigation form issue, I will have to think about
that one a bit and do some more examination.


-----
Microsoft Access MVP 2008, 2009, 2011
If a post was helpful click the FOUND THIS HELPFUL link

Did this solve your problem?

Sorry this didn't help.


 
Question Info

Views: 1,928 Last updated: June 4, 2018 Applies to: