Question Trouble saving as accde (1 Viewer)

Klegg72

Registered User.
Local time
Yesterday, 17:58
Joined
Jan 21, 2011
Messages
71
Hello,
I am about to allow users to access a database I redesigned for others to use.
I am trying to save it as an ACCDE so they can't mess it up. The database is very very simple.

6 tables each with only 4 fields or less... and none are related to one another
7 forms.
1 report.
0 queries... it's just a SKU generator.

When I attempt to save as ACCDE I get an error that reads.

"Microsoft Access was unable to create the .accde, .mde, or .ade file.
This error is usually associated with compiling a large database into an MDE file.* Because of the method used to compile the database, a considerable number of TableID references are created for each table.* The Access database engine can only create a maximum of 2048 open TableIDs at one time.* Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE.* However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used."


Is there anything anybody can think of that might cause this? It seems like a weird error considering the database is so simple/small.

Thanks!!!
 

mahenkj2

Registered User.
Local time
Today, 06:28
Joined
Apr 20, 2012
Messages
459
Not sure, but did you compile the dB before .accde conversion. In the VBA editor, debug, compile.
 

Klegg72

Registered User.
Local time
Yesterday, 17:58
Joined
Jan 21, 2011
Messages
71
Mahenkj2, You are a gentleman(or Lady... idk) and a scholar!!!!!!!!!!!!!

Thank You!!
 

Users who are viewing this thread

Top Bottom