Problem creating MDE after adding another Report

[Guest]

I have an application that I have created an MDE many times in the past with
no problems. I just added another report, and associated parameter query
form and query and, for some reason, now cannot create an MDE.

When I now use the menu option to create an MDE, after selecting the folder
for the MDE file, a file db1.mdb is created with the same size as my
application in the target folder, no MDE is created. If I then click the
mouse in the Access screen area, Access becomes non-responsive with an Hour
Glass.

The added report, form, and query increased the application file size from
3,412 KB to 4,328 KB and code in the modules affected all compile ok.

Several months ago someone reported the same problem, and the recommended
solution was to go and save all related forms, etc. because one of them in a
"not saved" state could cause a problem. That apparently worked for the
person back then, but I followed that suggestion and it does not solve the
problem.

Any idea what is happening?

Thanks,

John

 

[Albert D. Kallal]

I have an application that I have created an MDE many times in the past
with
no problems. I just added another report, and associated parameter query
form and query and, for some reason, now cannot create an MDE.

When I now use the menu option to create an MDE, after selecting the
folder
for the MDE file, a file db1.mdb is created with the same size as my
application in the target folder, no MDE is created. If I then click the
mouse in the Access screen area, Access becomes non-responsive with an
Hour
Glass.

The added report, form, and query increased the application file size from
3,412 KB to 4,328 KB and code in the modules affected all compile ok.

Several months ago someone reported the same problem, and the recommended
solution was to go and save all related forms, etc. because one of them in
a
"not saved" state could cause a problem. That apparently worked for the
person back then, but I followed that suggestion and it does not solve the
problem.

Any idea what is happening?

Thanks,

John

 

[Albert D. Kallal]

opps, bumped the send key..sorry...

can you while looking at code do a debug->compile....try that...

 

[Guest]

Yes, I can do debug compile and all ok. Also tried Database Utilities
compact, repair database, and nothing happened so I'm guessing that was ok as
well.

Thanks

John

 

['69 Camaro]

Hi, John.

I just added another report, and associated parameter query
form and query and, for some reason, now cannot create an MDE.

Please 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 and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

Gunny,

Thanks for the reply. All checklist items were ok. I was finally able to
create the MDE by making multiple copies of the mdb and systematically
deleting the new objects and trying to create the MDE. I found one form was
the problem. Its code would compile. I went into VB editor, then back to
design view, did another save and all ok.

John

 

['69 Camaro]

You're welcome. Glad you found the problem and fixed it.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.