Can I remove objects in MSACCESS mdb and create mde?

[le mistral]

I've run into the problem of exceeding 2048 table entries when trying to
create a .mde file from a .mdb file. I removed several forms but keep getting
the same error message. Compacting the database doesn't seem to help. I
have been able to create a .mde file in the past, so removing some forms
should fix the problem, but it hasn't.

 

[tina]

try creating a new, blank database. if you're using A2000 or newer,
immediately turn OFF the Name Autocorrect option, from the menu bar under
Tools | Options | General tab.

import all objects from your "old" database, into the new one. open a code
module and make sure your code compiles. then compact the database. now try
making a .mde file.

hth

 

[Tony Toews]

I've run into the problem of exceeding 2048 table entries when trying to
create a .mde file from a .mdb file. I removed several forms but keep getting
the same error message. Compacting the database doesn't seem to help. I
have been able to create a .mde file in the past, so removing some forms
should fix the problem, but it hasn't.

Just curious. How many forms, reports and modules do you have in the
MDB?

I'd agree with Tina that importing into a new MDB would be the first
thing to try.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm