Unable to create mde file

[Guest]

Hi,
My application has 5 forms, 7 tables and 110 reports, which are basically
the same but just have page margin variations. I set the "has module"
property on the reports to "no."

When I try to create the mde file, Access say's it's unable to do so because
there may be too many table reference ID's.

I'm trying to create an mde file to then package and distribute.
Any help on a work-around solution?

Thank you!
Karl

 

[Guest]

Karl:

What I have had the most success with is to go into the VB Editor, choose
Debug, and then Compile. Once the db has been compiled, Access is much nicer
about creating the MDE.

HTH

Sharkbyte

 

[Guest]

Hi Sharkbyte,
Thanks for your reply. I did find some old code I forgot to delete &
cleaning this up did allow the mde file creation. Thank you!
Karl