Access was unable to make a .mde file

[Mota]

Hi;
Although i meet the conditions for making a mde file mentioned in Access
2000 help file,when I try to make a mde file from my front end .mdb this
message box appears after a few seconds:
Microsoft Access was unable to make a MDE file
I use Acc 2000 on Win Me,and making a mde from my DataDB (back end mdb file)
that contains only tables,has no problem.
Does anyone have a comment to solve my problem?
Thank you in advance for ur help.

 

['69 Camaro]

Hi.

Check the "Can't make an MDE!" checklist on 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.)

 

[Allen Browne]

If everything else is in order, the problem is either a corrupted mdb or a
problem with the Office installation.

1. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

2. Make sure you have turned off the Name AutoCorrect options under:
Tools | Options | General

3. Compact the database:
Tools | Database Utilities | Compact.

4. Open a code window and check your references, making sure you have only
the ones you need. Details:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If that still fails, follow the steps in the first symptom in this article
to get Access to rebuild the database for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

 

[Allen Browne]

That's a good article, Gunny.

A keeper.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message

 

['69 Camaro]

Thanks, Allen!

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

 

[Mota]

Oops;
i had forgotten to Compile DB before making MDE.
Im wondering why Access 2000 help file has not pointed to this main
condition for converting to mde (and you and Gunny too).I remembered it
seeing the switch /Decompile u mentioned in ur reply.
Thank you for that clue.

 

['69 Camaro]

Hi, Mota.

Im wondering why Access 2000 help file has not pointed to this main
condition for converting to mde (and you and Gunny too).

I beg your pardon. I _did_ point this out to you. I pointed you to the
"Can't make an MDE!" checklist on this linked Web page:

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

The very first item on the checklist reads:

1. Does the code compile? (This is the most common reason for failing to
create the MDE format.)

For an explanation on why Access Help doesn't mention this in the error
message, please see the following Web page, if you care to read that either:

http://groups.google.co.uk/groups?hl=en&lr=&[email protected]

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