Error in making MDe

[kasa74]

Hi guys,

I am having error message when I tried to make my mdb file to mde. The error message is "MS Access unable to create an MDE database". Reading through the help message it says that this problem always occurrs in trying to compile large db into MDE. So what can I do to solve this problem. Also what is MS access memory capacity. thanks

 

[Rabbie]

Which version of Access are you using?

 

[CraigDolphin]

It might also be due to an un-discovered error in a vba code module in your mdb. Open the vba enditor and go to the debug menu>compile. If you cannot compile the mdb succesfully without something being highlighted as an error, then the converesion to mde will not work.

 

[kasa74]

I am using MS access 2003

 

[boblarson]

Do like Craig suggested. Go into the VBA IDE Window (see here for instructions on how to get to the code window, if you don't know how: )
http://www.btabdevelopment.com/main/QuickTutorials/Howtogettothecodewindow/tabid/72/Default.aspx

Then, go to DEBUG > COMPILE to compile. If there are errors it will take you to them. After each fix, do the DEBUG > COMPILE again until it compiles without error. Then you will likely be able to convert to an MDE.

 

[Exodus]

I recently had a simular issue. I had to decompile compact compile and compact again and all went well afterwards.

 

[kasa74]

Hi all,

I am making so changes to an access database. I want to add a combo list and I want the list to store its data in a table that other forms are storing their data. What do I do. Do I add a new field to the table, after creating the combo list, how do I make it store its data for each client in that table. I hope I am making sense.

thanks