Troubleshooting the error “Database too large, not copying. Access properties skipped” when scanning Access databases using OMPM for Office 2010

  • Article

We've seen several recent reports of customers hitting the following errors when using OMPM to scan Access databases:

  • Database too large, not copying. Access properties skipped.
  • Not logging Access properties for database.

One of our Microsoft consultants, Sebastien Roche, discovered a workaround to fix this issue:

Modify the OMPM configuration file (offscan.ini) as follows:

Set MaxCopyFileSize=300            ;or a size larger than your largest database

If you set this parameter large enough, you may still receive a "timeout error." In that case, you have to modify the values of the parameters RetryCount & RetryInterval as follows:

[Network]

RetryCount=15                ;set this to the number of retries per file you would like before moving on

RetryInterval=1500        ;set this to the number of milliseconds to wait between retries.

The downside to this workaround is that OMPM scan performance is slow.

Comments

  • Anonymous
    January 01, 2003
    You can solve out your problem by Access database recovry www.access.recoverytoolbox.com

  • Anonymous
    January 01, 2003
    John, I pass your question to some Access experts and they suggest the following: You’ll need to do something like this in C#.            Form f = a.Forms[0];            foreach (Control c in f.Controls)            {                foreach (_AccessProperty p in c.Properties)                {                        ….                }            }

  • Anonymous
    December 15, 2010
    Hello, Sorry to highjack this post, but I couldn't find the answer to my question anywhere. It does relate to scanning Access databases, though. I wonder (not out of sheer curiosity of course) if it is possible to go through all the properties of Access objects (forms, controls, reports) from .NET app (C# in particular) using Microsoft.Office.Interop.Access? From inside of Access I can do something like this: For Each ctl In Frm.Controls  For Each prp In ctl.Properties .... But I couldn't find how to access properties' names and values using C#. Properties[index] doesn't give me anything at all. And it seems like there is no Property type as well to use in Foreach. Can you point me in a right direction please? Thank you.

  • Anonymous
    December 21, 2010
    Hello Jill, This is brilliant! Thanks a lot, John