Re: Can I remove objects in MSACCESS mdb and create mde?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

le mistral <le mistral@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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
.

Relevant Pages

  • Error 3045 on an MDE file - HELP
    ... to but didn't want them messing so I created an MDE file. ... However, if one of the users goes into the database, it does not create ... and LDB file and if anyone else tries to get it, the error message: ... Some of the tables in the MDE files were linking to and MDB ...
    (microsoft.public.access.conversion)
  • Creating MDE Problem
    ... But when i try to create mde file i get the error: microsoft access 2000 ... create window error and go out of the program. ... What i need to do to revive my mdb and what can cause the problem? ...
    (microsoft.public.access.formscoding)
  • Re: close / rename linked .mdb file
    ... won't let me rename the file, I assume because the links exist. ... What's the error message when you try to rename the file? ... It sounds like that MDB file is still in use somewhere. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Make MDE file
    ... It has happened to me when there is a missing reference on the project. ... > When I try to make MDE file. ... I got error message " Microsoft Access was ...
    (microsoft.public.access.tablesdbdesign)
  • Make MDE file
    ... When I try to make MDE file. ... I got error message " Microsoft Access was ... unable to create an MDE database". ...
    (microsoft.public.access.tablesdbdesign)