Access was unable to make a .mde file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mota - 20 Jan 2005 02:13 GMT

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.

Reply to this Message

'69 Camaro - 20 Jan 2005 03:25 GMT

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

> Hi;
> Although i meet the conditions for making a mde file mentioned in Access
[quoted text clipped - 5 lines]
> Does anyone have a comment to solve my problem?
> Thank you in advance for ur help.

Reply to this Message

Allen Browne - 20 Jan 2005 03:35 GMT

That's a good article, Gunny.

A keeper.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi.
>
[quoted text clipped - 23 lines]
>> Does anyone have a comment to solve my problem?
>> Thank you in advance for ur help.

Reply to this Message

'69 Camaro - 20 Jan 2005 04:06 GMT

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

> That's a good article, Gunny.
>
[quoted text clipped - 27 lines]
> >> Does anyone have a comment to solve my problem?
> >> Thank you in advance for ur help.

Reply to this Message

Allen Browne - 20 Jan 2005 03:26 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi;
> Although i meet the conditions for making a mde file mentioned in Access
[quoted text clipped - 6 lines]
> Does anyone have a comment to solve my problem?
> Thank you in advance for ur help.

Reply to this Message

Mota - 22 Jan 2005 01:50 GMT

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.

> If everything else is in order, the problem is either a corrupted mdb or a
> problem with the Office installation.
[quoted text clipped - 36 lines]
> > Does anyone have a comment to solve my problem?
> > Thank you in advance for ur help.

Reply to this Message

'69 Camaro - 22 Jan 2005 05:07 GMT

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=&selm=OO%24AKNK1EHA.2624%40TK2MSFTNGP
11.phx.gbl

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

> Oops;
> i had forgotten to Compile DB before making MDE.
[quoted text clipped - 44 lines]
> > > Does anyone have a comment to solve my problem?
> > > Thank you in advance for ur help.

Reply to this Message