Unable to Create ADE

[Woody]

I am using Access 2007. I am using SQL Server as the back-end to a project.
I want to create an Execute only version of the project. From the Database
Tools tab I select Make ADE. Access suggests a file name with an ADE
extention and I select Save. However, I get back a message that says,
"Unable to create ADE database." I am not given an explanation, just an OK
button.

Does anyone know what the problem and more important, the solution is?

 

[Ken Snell \(MVP\)]

Often, the problem is caused by an error in the VBA programming, which will
prevent the creation of an .ade (or .mde) file.

Open the Visual Basic Editor, and compile the code. Fix all the errors that
are identified, then try to make the .ade file again.

 

[Woody]

That was the problem. I had some code that was creating an error when
loading a form. When I eliminated the bad code the ADE was created without a
problem.

Thank you