Creating an accde file

[djsmith]

We are attempting to create an accde file for our front-end database. We get
the following error message "Microsoft Office Access was unable to create the
..accde, .mde, .or . ade file." The help description indicates: "...The Access
database engine can only create a maximum of 2048 open TableIDs at one time."

As we have the database backed up, we removed a fairly good portion of the
queries, forms and report and removed all of the linked tables. To try to get
the file size down to a minimum.

Any insight into what we can do will be greatly appreciated.

 

[Arvin Meyer MVP]

Occasionally, error messages are cryptic and actually mean something else
because there is no good error description. So do the following in the order
presented and try again. Always work on a copy to avoid any chance of
corrupting your file.

1. Run a compact and repair on your database

2. If the above is successful, open any code window and compile the code.

3. Fix any errors the compilation process shows, until the database cleanly
compiles.

4. Once everything is clean and working compact and repair again.

5. Now try to create your .accde again.