Creating accde file

[kenista]

I am in the final stages of creating my database in access 2007 and it will
not allow me to create an accde file when I click on the make accde button.
It comes up with an error message saying 'Microsoft Office Access was unable
to create the .accde, .mde, or .ade file'

Please help - I would really like to do this as I don't want the users to
play around with the code etc.

Thanks in advance.

 

[Allen Browne]

Here's a checklist of things to work through:
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

 

[Daniel Pineault]

One common reason is that you may have errors in you VBA Programming that are
preventing the conversion to an ade file.

Perform a compile, in the VBE, and fix any errors with your code that are
raised.
Also, I would recommend performing a compact and repair.
Then try again.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[kenista]

Thanks for the suggestions.

I will give them a go and post pack if it doesn't help

 

[Spidey]

Hi Daniel..
Thanks for your solutions..It works!!!

 

[joelgeraldine]

^**

Hi Daniel..
Thanks for your solutions..It works!!!