MDE

S

SPMU

I'm getting a message "Microsoft Access was unable to make an MDE database".
I've tried creating a new database. I've checked MS site for fix, but cannot
get it to work. Any Suggestions anyone?


Thanks
 
C

Cheryl Fischer

Two possibilities come to mind:

1. There may be coding errors in the database; these will
prevent the creation of an MDE. Open any code module and, from the VBA
menu, select Debug, then Compile. If there are any errors, you will see an
error message and the problem line of code will be highlighted. Continue
compiling until the compile completes with no messages at all.

2. If you are using Access 2002 or 2003, the default database format is
Access 2000. Unfortunately, if you use the Access 2000 database format in
Access 2002/3, you cannot create an MDE. You may only create an MDE of an
Access 2000-format database using Access 2000.

hth,
 
S

SPMU

Cheryl,

Thanks, I just needed to be reminded of this, I had forgot. It now works
like a charm. Again thanks.

Two possibilities come to mind:

1. There may be coding errors in the database; these will
prevent the creation of an MDE. Open any code module and, from the VBA
menu, select Debug, then Compile. If there are any errors, you will see an
error message and the problem line of code will be highlighted. Continue
compiling until the compile completes with no messages at all.

2. If you are using Access 2002 or 2003, the default database format is
Access 2000. Unfortunately, if you use the Access 2000 database format in
Access 2002/3, you cannot create an MDE. You may only create an MDE of an
Access 2000-format database using Access 2000.

hth,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top