Please help!

[Hiba87]

Greetings!

Straightforwardly, whenever I convert an access database (I have built) to ACCDB pops up the following message:

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


I left no stone unturned to solve the problem, I found the following steps:

"1. Press Alt + F11 to display VBA editor.
2. In the menu 'Debug' , you will find 1st menu item as 'Compile AccessDb'.
3. Click that option.
4. If there is no error, the database will get compiled.
5. If during compilation, any error is encountered, the VBA editor will display that error and you can rectify that.
6. Once all errors get rectified, you will be able to compile the database."

I went through them, yet to no avail. When I hit compile database (via the VBA) I got a message reads (Compile error: user-defined type not defined), given that I previously converted another database that contained a similar code, but I did not receive that message back then. Does such an error has anything to do with the size of the database because the current database is a way larger than the previous one?

Please advise.

One final tiny question, when I convert the database into ACCDB, the encoded buttons stop working. Is there a way to make them work again?

Regards,

 

[Ranman256]

debug the error. I get these occasionally when i forget to declare something.

(which sounds like what you have)
the compile should show you the offending line.

and when you give the db to another person, their Macros are prob. disabled.
Enable all macros (file,options,) and the buttons will work again.
File, options, trust center, trust center settings, macro settings, ENABLE ALL MACROS

 

[isladogs]

whenever I convert an access database (I have built) to ACCDB pops up the following message:

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

That message is seen when there are problems creating an ACCDE file from an ACCDB file
Are you sure you aren't trying to create an ACCDE file (Access executable) rather than an ACCDB file?