ACCDE creation errors out

[So Call Me Crazy]

I am getting an error message that Access 2007 cannot create an ACCDE for my
database. The explanation says that perhaps my DB is too big.

I only have 14 tables (they are linked to another .accdb and most have no
more then 20 records), 3 forms, 1 report, 1 module. This just isn't a large
DB.

TIA!

 

[John W. Vinson]

I am getting an error message that Access 2007 cannot create an ACCDE for my
database. The explanation says that perhaps my DB is too big.

I only have 14 tables (they are linked to another .accdb and most have no
more then 20 records), 3 forms, 1 report, 1 module. This just isn't a large
DB.

TIA!

Try Compact and Repair before you start converting to an accde; if you have
any VBA code make certain that it compiles with no errors. It's possible that
your database is corrupt in some way and this is a bogus error message.

 

[So Call Me Crazy]

Thank you! I had a compilation error and didn't know it!

You wouldn't happen to know how to get rid of the message bar in the
application would you?

 

[John W. Vinson]

Thank you! I had a compilation error and didn't know it!

You wouldn't happen to know how to get rid of the message bar in the
application would you?

I'm afraid not; I've not installed 2007 yet.

 

[Bob Larson]

Here's a visual on how to do it for you:
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

--

Thanks,

Bob Larson
Access MVP

Free Access Tutorials and Resources: http://www.btabdevelopment.com