Re: Problems Making MDE.....

From: GVaught (glvaughtRemoveThis_at_hotmail.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 16:52:38 -0700

Removing modules or forms is not necessary.

Just run the Debug | Compile all modules from the Code Editor window and the
problem will be highlighted, so you know exactly what code is the problem.

"Nate" <anonymous@discussions.microsoft.com> wrote in message
news:23f101c3fc78$2003f070$a501280a@phx.gbl...
> I have never made a large MDE database but when I have
> had trouble making an MDE database the problem has been
> in the VBA code. I removed modules and forms until it
> compiled then to identify the problem modules.
>
>
> >-----Original Message-----
> >After spending a great deal of time developing a
> software package, I went to make a MDE, I received this
> error.
> >
> >This error is usually associated with compiling a large
> database into an MDE file. Due to the method used to
> compile the database, a considerable number of TableID
> references are created for each table. The Microsoft Jet
> database engine version 4.0 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 Jet 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.
> >
> >To see if this was the problem, I remove all but a few
> tables, and forms and retried. Got the same message.
> >.
> >

Relevant Pages

  • Re: MDE not possible ?
    ... First compile the MDB and make sure that there are no errors in the code ... before creating the MDE. ... Because of the methode used to compile the database a lot of references ... If your database is in Access 2000 file format (it should say on ...
    (microsoft.public.access.formscoding)
  • Re: Secure Payroll information w/o using Access Security
    ... compile, followed by Save). ... I thought the MDE would be a good approach, but I tried to create an MDE ... "This error is usually associated with compiling a large database into ... Create a startup form that is opened ...
    (microsoft.public.access.security)
  • Re: Secure Payroll information w/o using Access Security
    ... "Joan Wild" wrote: ... compile, followed by Save). ... I thought the MDE would be a good approach, but I tried to create an MDE ... "This error is usually associated with compiling a large database into ...
    (microsoft.public.access.security)
  • Re: Problems Making MDE.....
    ... It is true that failure to produce an .mde can be due to number of objects, ... Due to the method used to compile the database, ... database engine version 4.0 can only create a maximum of 2048 open TableIDs ...
    (microsoft.public.access.conversion)
  • Re: error in making a mde file
    ... Compact and Repair again and then compile. ... Then try to make MDE again. ... database into an MDE file. ... There is no accurate method to estimate the number of TableIDs the Jet ...
    (microsoft.public.access.gettingstarted)
Loading