Isolate the source of converting problems from Access 02 MDB to MDE??? 1

[djarman]

I have an MDB that I recently converted a majority of the queries into VBA code within each form. All the converted queries have been converted into public or private sub procedures with DoCmd.RunSQL "name" as the format.

I wanted incorporate these queres to create an MDE file so others can't alter the queries that the forms are dependent on. In having complete this monster task, now the MDB will not convert to an MDE. The file was created in Access 2000, converted to 2002, then attempted to be converted into an MDE.

When I tried to convert the previous file (before the VBA inclusion of the queries), I was successful at creating the MDE. My hopes is that there is a way to locate the cause of this conversion failure (to an MDE from Access 2000), rather than starting back at the drawing board with the previous file.

Any help woudl be greatly appreciated.

 

[PHV]

Check the references:
while in VBE, menu Tools -> References ...
Did the database compile properly ?
menu Debug -> Compile

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[djarman]

Thank you. I was able to go back through the program form by form to isolate the problem. I have been making changes, saving, then creating .MDE files to make sure that the file is able to be made into a MDE file.

I have found that when there were problems in the code that I may have not worked, the MDE file function would not work. This is probably a good thing, so I can isolate the problems with the code. Some of these problems are not picked up with debugging the code.

Thanks for your suggestion.