Can't Create MDE

[JamesJ]

I am unable to create an mde file from my mdb. Access 2003 says:

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).

Any help will be appreciated
James

 

['69 Camaro]

Hi, James.

Check the "Can't make an MDE!" checklist at the following Web page to help
you determine why you can't create the MDE database:

http://www.Access.QBuilt.com/html/conversion.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[JamesJ]

No to all. I was able to create one before I
formatted my hard drive and reinstalled access 2003!

James

 

['69 Camaro]

Hi, James.

No to all.

That means you've found 11 reasons why you can't create the MDE file. From
the second paragraph: "If any of your answers are “No,” then you’ve found
one of the stumbling blocks that is preventing Access from converting your
database into an MDE format."

May I assume that you mean "None of those reasons are preventing Access from
converting my MDB database to an MDE database file"?

I was able to create one before I
formatted my hard drive and reinstalled access 2003!

Does your MDB database file have some linked tables or else tables that your
VBA code or object properties are pointing to that now use invalid paths?
For example, if a table was referred to in a database file previously
located at E:\Data\MyDB.mdb and is now G:\RestoredData\Data\MyDB.mdb, then
Access won't be able to find that file and can't create an MDE database
file.

If this isn't the case, then start troubleshooting to determine whether it's
the new installation of Access or the database file itself. Create a new
database in Access 2002/2003 format and put some tables, queries, forms and
modules with VBA code in it. Save the database in the same directory as
your problem database. Make sure that you follow the "Can't make an MDE!"
checklist to ensure that Access should be able to make an MDE database file
from this new database.

If that works, then create a new database file and import all of the objects
from the problem database, compile the code, then try to create an MDE
database file from it.

What errors, if any, do you encounter?

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[JamesJ]

Yes. One thing though. Why does access display that error
text that I copied and pasted in my first post? I don't see
anything in the 11 reasons that even resembles the access message.
Must be an access way of confusing me more.

James

 

['69 Camaro]

Hi, James.

Why does access display that error
text that I copied and pasted in my first post?

The Access Help message, "This error is usually associated with compiling a
large database into an MDE file," explains the most common reason why an MDB
file can't be converted into an MDE file when a trained database application
developer is building the application, because these developers have been
trained to ensure that all of the correct conditions already exist prior to
making the MDE database file.

However, in the real world, it's probably one of the _least_ likely reasons
people will ever encounter -- simply because most folks building Access
databases aren't trained database application developers. They're trained
experts in other fields and just need a computer solution that helps them do
their jobs better and faster, and be more productive. And now that you've
read the checklist, you know the required conditions that the trained
database developers are trained to ensure, so you can add this to your
repertoire of knowledge and expertise in your current job.

I don't see
anything in the 11 reasons that even resembles the access message.

Sorry. It's not currently listed on the Web page. Most people reading
those reasons have already read the Access Help message and found that it
didn't apply to their particular situation, so they are looking elsewhere
for the answer. We figured that listing this reason yet again on our Web
site would come under the Department of Redundancy Department. You aren't
the first person who has mentioned that it isn't listed as one of the
reasons, though. You will be the last, however, because this will soon be
fixed.

Must be an access way of confusing me more.

You have dents in your skull from banging your head on the monitor, too? I
thought it was just me.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[JamesJ]

I uninstalled access and reinstalled it and it seems fine now.
I found two problems that could have been the reason. I had
two missing references and I had changed the path to my
linked tables once but forgot the second time around when
I copied my backup top my working folder. Got my mde and
my mdb.
I can see why those developers do it that way not knowing
what some of us might do.

Thanks much,
James

 

[Chris Mills]

Amusing post Gunny!

I couldn't think of more than those 11. I see you have a 12th (DORD) and 13th
(The missing link) to add!

(again[!], amusing post...)
Chris

Hi, James.

...trained monkeys...Department of Redundancy Department(was that

intentionally redundant?)...dents in your skull...

 

[Chris Mills]

If you had missing references, then either the app did not compile, or the
missing references weren't necessary at all. That is the sole reason for
including references! Get rid of as many as you can.

I'm pleased to see Gunny covered both the possible errors you mention.

Chris

 

['69 Camaro]

Hi, James.

You're welcome! Glad you got it all sorted out and your computer is stable
again.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

['69 Camaro]

I'm pleased to see Gunny covered both the possible errors you mention.

Me, too! ;-)

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

['69 Camaro]

Hi, Chris.

I see you have a 12th (DORD) and 13th
(The missing link) to add!

Yup. If you run into any others, please let us know and we'll add those,
too.

Now, don't put words in my mouth! I wrote "trained database application
developers," not "trained monkeys" or even "missing links." I've never
actually seen a trained database application developer, but in my profession
I've heard that these people do exist. (I'm a trained Oracle DBA, I've
worked with a few other trained Oracle DBA's, and I've even worked with a
trainer for Oracle DBA instructors, so word gets 'round about the database
problems we encounter). But perhaps these developers' jobs have migrated to
India, China and Eastern Europe, because I haven't heard of any sightings
around here for several years.

intentionally redundant?)

Yes. Affirmative. It was intentionally done on purpose.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

Amusing post Gunny!

I couldn't think of more than those 11. I see you have a 12th (DORD) and 13th
(The missing link) to add!

(again[!], amusing post...)
Chris

message
Hi, James.

...trained monkeys...Department of Redundancy Department(was that

intentionally redundant?)...dents in your skull...

 

[Chris Mills]

Well, trained people should know that there's a train coming? Ha-Ha

or another one: I am posting to inform you that I have nothing to say! Tee-Hee

Actually I do: from my other post:
"If you had missing references, then either the app did not compile..."
-Recently someone possibly Doug Steele, reminded us that Option Explicit
should be used to do a proper compile, possibly also for references. I do that
anyway, but a reminder is always worthwhile...

Chris

 

[david epsom dot com dot au]

Yup. If you run into any others, please let us know and we'll add those,


:~)

Permission errors: you need to have permission on the /library mde/ as
well as on the base mdb.

My most common problem has to do with scripted builds and the InprocServer32
registry entries, but I think that is probably a bit too obscure for public
consumption... :~)

(david)

Hi, Chris.

I see you have a 12th (DORD) and 13th
(The missing link) to add!

Yup. If you run into any others, please let us know and we'll add those,
too.

Now, don't put words in my mouth! I wrote "trained database application
developers," not "trained monkeys" or even "missing links." I've never
actually seen a trained database application developer, but in my profession
I've heard that these people do exist. (I'm a trained Oracle DBA, I've
worked with a few other trained Oracle DBA's, and I've even worked with a
trainer for Oracle DBA instructors, so word gets 'round about the database
problems we encounter). But perhaps these developers' jobs have migrated to
India, China and Eastern Europe, because I haven't heard of any sightings
around here for several years.

intentionally redundant?)

Yes. Affirmative. It was intentionally done on purpose.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

Amusing post Gunny!

I couldn't think of more than those 11. I see you have a 12th (DORD) and 13th
(The missing link) to add!

(again[!], amusing post...)
Chris

message
Hi, James.

...trained monkeys...Department of Redundancy Department(was that

intentionally redundant?)...dents in your skull...

 

['69 Camaro]

Thanks, David!

My most common problem has to do with scripted builds and the InprocServer32
registry entries

You're a hard core programmer!

but I think that is probably a bit too obscure for public
consumption... :~)

You're probably right. Some are scratching their heads and thinking,
"What's a scripted build? What's an InprocServer32?"

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

Yup. If you run into any others, please let us know and we'll add

those,


:~)

Permission errors: you need to have permission on the /library mde/ as
well as on the base mdb.

My most common problem has to do with scripted builds and the InprocServer32
registry entries, but I think that is probably a bit too obscure for public
consumption... :~)

(david)




message news:[email protected]...

Hi, Chris.


Yup. If you run into any others, please let us know and we'll add those,
too.


Now, don't put words in my mouth! I wrote "trained database application
developers," not "trained monkeys" or even "missing links." I've never
actually seen a trained database application developer, but in my profession
I've heard that these people do exist. (I'm a trained Oracle DBA, I've
worked with a few other trained Oracle DBA's, and I've even worked with a
trainer for Oracle DBA instructors, so word gets 'round about the database
problems we encounter). But perhaps these developers' jobs have

migrated

to
India, China and Eastern Europe, because I haven't heard of any sightings
around here for several years.

...Department of Redundancy Department(was that
intentionally redundant?)

Yes. Affirmative. It was intentionally done on purpose.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

Amusing post Gunny!

I couldn't think of more than those 11. I see you have a 12th (DORD)

and
13th

(The missing link) to add!

(again[!], amusing post...)
Chris

"'69 Camaro" <[email protected]_SPAM>

wrote
in

message
Hi, James.

...trained monkeys...Department of Redundancy Department(was that
intentionally redundant?)...dents in your skull...