Can I remove objects in MSACCESS mdb and create mde? le mistral 01.08.2006 17:34:02 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.

Re: Can I remove objects in MSACCESS mdb and create mde? "tina" <nospam[ at ]address.com> 02.08.2006 02:18:46 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 "le mistral" <le mistral[ at ]discussions.microsoft.com> wrote in message news:21C296B5-7DE0-4030-A92A-732F56D0313C[ at ]microsoft.com... [Quoted Text] > 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.

Re: Can I remove objects in MSACCESS mdb and create mde? Tony Toews <ttoews[ at ]telusplanet.net> 04.08.2006 01:39:41 le mistral <le mistral[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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