won't let me make a .mde file. Any ideas?

[misys]

Using access2002, developed application, have split the the application to have the data in a separate file. Now trying to secure the application. followed the instructions the "make mde file" option is available, clicked on that, it looking for a name, have let the system pick one and also have tried picking my own, in both situations the error comes up, Access has encountered a problem and has to shut down, I have chosen to send the problem to Microsoft at that point and other times have not. Access then creates a backup and then shuts down. This happens every time. Anyone know why, or what I'm doing wrong. Is it because the application is split? if so can you tell me how to un split it... haven't found how to do that yet either. I can move the data file and refresh the links to the new location but not un split it. don't know if this is even possible? Any help would be appreciated.

 

[danvlas]

Try to compile the code in the front end. Any compile error must be removed before attempting to create an mde file.

To unsplit the database: open the back-end and import all queries, forms, reports, macros and modules from the front end.

Hope this helps.

Happy New Year!
Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[Magellan]

Hi,

I am using Access10Dev and have a split database. But that's nothing got to do with making mdes. Either way you can do it i.e. make mde then split or first split 'n then make mde. Keep in mind that the front end i.e. mdb with forms,modules etc can be transformed into a mde type not the back end data file which usually has the name like app_be.mdb
Anyways check for errors in your VBA code if u aren't able to make mde either way. Try 'n compile the code. That way u can check for errors. Hope your software has a clean install with the requisite service packs.

Hope this helps.

In the sweat of thy brow shall you eat your bread