Re: MDE not possible ?

Hi again,

I converted my frontend MDB to the Access 2002-2003 format and tried to
create a MDE.
I get an error that the MDE couldn't be created.
Since I havea dutch Access version the error is also in dutch so I try to
translate it best I can:
My database consists of 4 linked tables to the SQL server and has less then
20 forms, modules and queries.
The MDB is about 2 mb in size.

Error message when creating the MDE:

This error occurse mostly while compiling big databases to a MDE file.
Because of the methode used to compile the database a lot of references will
be created to table-ID's for every table. The MS Jet engine alows maximum of
2048 open table-ID's at one time.
If there is a large number of tables, forms, modules and reports this could
exceed the limit during compiling.

Dutch version :
Deze fout heeft meestal te maken met het compileren van een grote database
naar een MDE-bestand. Vanwege de methode die wordt gebruikt voor het
compileren van de database, wordt er een aanzienlijk aantal verwijzingen
naar tabel-id's gemaakt voor iedere tabel. De Microsoft Jet Database Engine
versie 4.0 kan maximaal 2048 open tabel-id's per keer maken. Als de
database een groot aantal objecten bevat (tabellen, macro's, formulieren,
rapporten, etc.) en als MDE-bestand wordt geëxporteerd, kan deze limiet
worden overschreden.

Er bestaat geen nauwkeurige methode voor het schatten van het aantal
tabel-id's dat wordt gebruikt door de Jet Database Engine tijdens het
compileren van een database als een MDE. Elke VBA-module en elk formulier
maakt echter gebruik van een tabel-id. Als een database dus 500 formulieren
bevat en de eigenschap HasModule van elk formulier is ingesteld op Ja,
worden er wel 1000 tabel-id's gebruikt.




"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> schreef in bericht
news:u9TcAyS7GHA.3836@xxxxxxxxxxxxxxxxxxxxxxx
The default file format for Access 2003 is actually the Access 2000 file
format. If your database is in Access 2000 file format (it should say on
the database window), Access 2003 cannot convert it to an MDE: you must
convert the file format first. To convert to the new file format, look
under Tools | Database Utilities.

You can also change the default file format under Tools | Options, but
that will only affect any databases you create ongoing.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Rob Hofkens" <rob@xxxxxxxxxxxxxxxxxx> wrote in message
news:452cda5c$0$4513$e4fe514c@xxxxxxxxxxxxxxxxx
Hello eveyone.

First, I know little about a MDE but I think its a database that has
compiled VB code and it runs faster ?
Maybe I am totaly wrong about this but someone might explain a bit more.

Second, I have a Access 2003 front end and a SQL2000 Server back end.
When I try to create a MDE I get an error about the "file format from the
used database" (translated from dutch) .
The error window suggests to convert the data ??
Is this normal with my setup ?

Thanx in advance.

Rob.








.

Relevant Pages

  • Re: making a MDE file
    ... db format first and then convert that to mde. ... This error is usually associated with compiling a large database into an MDE ... There is no accurate method to estimate the number of TableIDs the Jet ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Creating MDEs
    ... including the inability to create an MDE. ... There may be coding errors in your database. ... >an MDE file from the ... database format is ...
    (microsoft.public.access.forms)
  • Re: unable to create mde
    ... You would need to convert the database to 2002 format in order to create an MDE using Access 2002. ... compiling until the compile completes with no messages at all. ...
    (microsoft.public.access.security)
  • Re: Cant Create MDE
    ... That means you've found 11 reasons why you can't create the MDE file. ... database into an MDE format." ... converting my MDB database to an MDE database file"? ...
    (microsoft.public.access.conversion)
  • Re: Error in creating MDE file
    ... Try compiling your database. ... errors, Access can't create an MDE (and yes, it's possible that there are ... >> This will create a new MDB file in 2002 format, and you will be able to ...
    (microsoft.public.access.tablesdbdesign)
Loading