Receiving an error when I compile large databases into MDE files

Asked By Joseph Abbott 20 points N/A Posted on - 10/08/2012

Hi,

I 'm receiving an error when I compile large databases into MDE files on Access 2007.

The particular files usually consist of split databases which may contain forms, report, modules, queries, and the like.

These would then possibly be linked to other databases also created in Access2007.

In light of this I have already removed unnecessary modules, forms, and codes, but it still will put out the error.

Does this error have anything to do with excess or inappropriate data?

Please help me.

Microsoft Office Access

Microsoft Office Access was unable to create the .accde, .mde, or .ade file.

Show Help>>

OK

• Status: Open
• Question Views: 847
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Bentley Michelle 0 points N/A #190373

Receiving an error when I compile large databases into MDE files

Hello,

I have heard of this problem and I had to take a look. This error happens when there are issues with the code in the database. If you open the database and go straight into the VBA window, you will be able to compile the database without any problems.

-debug menu>compile.

If you run into errors compiling the database this way, you will be able to fix those errors once you successfully compile the file and try to create another ACCDE file again.

Best regards.

About Bentley Michelle

Questions
1

Answers
11

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/08/2012
• Question Category: MS Access