Compiling to accde inhibits all VB

D

Dick Dodge

My accdb works great. Everything works. When I compile the accde I can run
any VB. I don't get any error / warning that I can see. I need help!
 
D

Dick Dodge

I tried this both before and after installing SP1 and yes I have it in a
trusted location. I did convert some of the simple vb which opened forms to
macros and those work fine after the compile. I have the macro setting to
disable with warning but I don't get any warning. Tried enabling all macros
and no change. I'm trying but not much headway. I appreciate the help.
Thanks
 
A

Allen Browne

My setting is "Disable all macros with notificaion" under:
Office Button | Access Options | Trust Center | Macro Settings

(I'm testing on Windows Vista, and the ACCDB doesn't actually have any
macros.)
 
D

Dick Dodge

That is my current setting also. I am using XP pro. Not sure of SP level.
Like I said below, macros work but VB doesn't in the accde but both do in the
accdb from trusted location and I don't get any warnings.
 
D

Dick Dodge

Yes, I posted with that message board also, can't get to much help when you
are a novice.
I solved the problem last night. Reviewed the 2007 documentation and found
a page on converting DAO to ADO.
http://msdn2.microsoft.com/en-us/library/bb256407.aspx
I went back and reviewed my code and found one select that I hadn't changed
to ADO. I made the change in my 2003 baseline code, compiled and saved and
tested. Opened it in 2007 and saved as 2007 format. Opened the 2007 format
and made my accde and it worked. I have a new problem but I'm past this one.
thanks for the help and interest.
 
Top