access 2007 accde

[Paul]

I have a large access 2003 program (30 mb).
I convert it to accdb format
Then I want to convert that to accde

I am told the propgram is too large and the hash tables are limited to 2048
entries. I am sure there are large access programs out there.

What to do? decompile/recompile.....how to do that in 2007?

thanks

 

[Allen Browne]

Paul, my suggestion would be to run a compact, decompile, compact sequence
on the old MDB.

Then create a new (blank) ACCDB, turn off Name AutoCorrect, import
everything, set your references, and compile. You should then be able to
create the ACCDE.

If you do want to do a decompile in the new version, it's just the same,
i.e. you close Access and execute it at the command prompt.

If you want more detail on any of the steps suggested above, this recovery
sequence provides the detailed steps for each:
http://allenbrowne.com/recover.html