Runtime error 2106 when opening report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there.

I'm having trouble with a report. I inserted an object as a link - a
word-document.
When closing the report afterwards Access told me that thing was too big for
the report but closed the report - so i had no chance to change it.

Now, when trying to open the report - nevermind whether in design or preview
view - i keep getting the following error message:
"1 errors occured when you loaded the form or report - You loaded a form or
report that has controls or properties that Microsoft Office Acces doesn't
recognize and will ignore".

Even when trying to access the report over the immediate window ( [CTRL] + G
) i get the error message
"Run-time error '2106': 1 errors occured when you loaded the form or report".

So, unfortunately i don't even get access to the controls on the report over
VBA - the error keeps coming up all the time.

As the report is rather big and has many conditional elements which took
quite some while to build, i'd really like to get access to it other than
starting from scratch.

Does anyone have an idea ?

Thanx a lot in advance..

Greets Fabian.
 
It sounds like the report is corrupt and you may not have any choice other
than rebuilding it. First, always work on a copy of the database. Working on
the original may make it impossible for a repair service to fix it. My first
efforts usually center around building a new database and importing the
objects. Corrupt objects generally won't import.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top