Compatibility Microsoft Access 2003 - 2007

[drimades]

Hi!

I have an Access 2003 db that does not work with Access 2007. Any idea?

 

[JoeAtWork]

I don't use Access2007 so I don't have an idea.
However, those that might know will probably want more information than "it does not work". What errors do you see? What is not working?

 

[evalesthy]

You might want to read this excellent article by Allen Browne (an Access MVP).

http://allenbrowne.com/Access2007.html

Might be a good start to answering some 2007 questions - worth reading regardless.

 

[drimades]

Thanks! I have a mask with some buttons in it. When I click on the buttons it doesn't make anything. It's just like the button_click action dooesn't exist ...

 

[evalesthy]

Is the button click event firing? Put a msgbox in the OnClick event and see if it runs.

msgbox"I'm firing", vbOKOnly, "Hello"

If it appears then your event if running - something else is wrong.

 

[jmgaddis]

Possibly due to VBA being disabled by default, when you first open the database near the top middle of screen you will see an Options button, try clicking on it and enabling VBA. If it doesn't let you click the Options button because your form is open, close your form and then click the Options button.

Then you can work around this issue by setting up Trusted Locations, click the Microsoft Button (top left of screen), then Access Options.

Hope this helps.

Thanks,
John

 

[boblarson]

And here's a VISUAL of what John wrote:

http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com