Compile from Database

[Stefan Moser]

Hi there,

I want to use the Option within the VBA Window Debugger --> "Compile from Database"
and for this I've two questions

If this compilation worked do I still have the VBA script in the VBA editor which I could Edit ?

And what do I have to do to compile old stuff with the following

Dim rst As ADODB.Recordset
Dim cnn As ADODB.Connection
Dim cat As New ADOX.Catalog



Thanks for your answer

[June7]

The Debug compile does not impact the VBA code. It is just a check of code to make sure there are no errors that will prevent the code running (such as missing End If statements - a common compile error). You should run the Compile after code mods. Try it, see what happens. See if the compiler has any issue with the 'old stuff'.

Also, run Compact & Repair after any design changes.

[Stefan Moser]

Thanks ! that helps

The Debug compile does not impact the VBA code. It is just a check of code to make sure there are no errors that will prevent the code running (such as missing End If statements - a common compile error). You should run the Compile after code mods. Try it, see what happens. See if the compiler has any issue with the 'old stuff'.

Also, run Compact & Repair after any design changes.