Access was unable to make a .mde file

  • Thread starter Thread starter Mota
  • Start date Start date
M

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.
 
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
 
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
 
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.
 
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).
Click to expand...

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