New error message when creating MDEs ??

[Guest]

Hi,

I'm not sure what the cause of this is but I am recently getting the
following error message when attempting to create an MDE file from my
database:

"Microsoft Access was unable to create an MDE database."

When I click the attached help button the message refers to issues with
Access not being able to create MDE files when the database is extremely
large with a great many tables. The issue however is that my database is not
extremely large. It has one table with about 3,500 records, but those records
are linked to the back-end file. Also a week ago I created MDE files from
this same database without problems. While I've been working on a new form
this past week that hasn't added a large amount of data to the file.

Plus the error message really offers little info that would help to fix the
situation.

Any thoughts?

Many thanks,
David

 

[Guest]

Make sure that your code is compiled. Do a Ctrl + G . Next go to Debug then
Compile. Fix any errors and try again.

 

[Guest]

Hey Jerry,

That did the trick!

Many, many thanks,
David