MDE Failure

[Guest]

I have a 48 Mb database with 26 tables. I added WORD and OUTLOOK references
to the reference library and created an automated report, but now I get a
failure when attempting to update the MDE and a message discussing too many
table ID and too large a database.

Is there any way to resolve this?

 

['69 Camaro]

Hi, Jeff.

now I get a
failure when attempting to update the MDE and a message discussing too
many
table ID and too large a database.

That "help" message is pretty misleading (and _really_ far off the mark).
Did you remember to compile the code after adding the libraries? That will
cause the MDE creation to fail. If that's not the problem, please check the
"Can't make an MDE!" checklist on the following Web page to help you
determine what's wrong:

http://www.Access.QBuilt.com/html/conversion.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

Thank you, Thank you, I haven't messed with an MDE for awhile and forgot
about compiling. No problems now. Have a great weekend!
--
Jeff C
Live Well .. Be Happy In All You Do

Hi, Jeff.

now I get a
failure when attempting to update the MDE and a message discussing too
many
table ID and too large a database.

That "help" message is pretty misleading (and _really_ far off the mark).
Did you remember to compile the code after adding the libraries? That will
cause the MDE creation to fail. If that's not the problem, please check the
"Can't make an MDE!" checklist on the following Web page to help you
determine what's wrong:

http://www.Access.QBuilt.com/html/conversion.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

You're welcome. Have a great weekend!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

Thank you, Thank you, I haven't messed with an MDE for awhile and forgot
about compiling. No problems now. Have a great weekend!

 

[dbahooker]

yeah the way to solve this is to move to Access Data Projects

seriously

don't keep mission critical data in a glorified SPREADSHEET

Access MDB doesn't even really allow transactions

it's time for SQL Server if you've got 48 tables