Hello, I have read comments that any code in 2003 'should' work in 2007. I am currently developing a PO system database and some (what I would call 'simple') code does not work in 2007. For example: List box selecting opening desired form: I have an option group with 3 choices and based on the choice a different list box becomes visible. In 2003, no worries...I can select the PO in the list box and the actual PO opens. In 2007 (not converted...just using the mdb), I can't make a selection in the list box. It just won't let me click. I will have users of this system on both versions and I don't want to continue development until I further understand compatibility issues. Any thoughts????
There are some differences in 2007, but in general any code that you write in 03 should run in 07. You must, however, "enable" macros in 07, and you should also place your database in a Trusted Location.
just a rant. What I mean is Office 2007 was created not with functionality in mind, but as eye candy. New toolbar, Ribbon, and all that. Functionality was not the main priority. Consequently, I don't see why would anybody use it if the purpose is to do things rather than admire the good looks.
If you're using ADPs, I'd strongly suggest that you stick with Access 2003. When we ported our ADP to Access 2007, we have so many issues that we quickly reverted and stuck with 2003. 2007 is dreadful for ADPs - performance is terrible....
Thanks for the responses...it seems that some code works and some don't. It took some time, but I figured out that my code on lost focus was wreaking havoc!!! It worked fine in 2003, but not 2007. I took it out and made other changes to the got focus and it works fine in both. I'm worried about what additional problems I may experience. ctudorprice: Not using ADPs, but good to know. THanks!
I always make sure my DB is in tip-top shape BEFORE testing it in 2007: 1. Run the Compact/Repair utility in Access 2003 2. Decompile the DB (http://www.granite.ab.ca/access/decompile.htm) 3. Import all database objects to a blank, new Access 2003 database. ... THEN test the db in Access 2007. If you still have problems, then create a copy of the db and convert it to the Access 2007 format and repeat steps 1 and 3 only for Access 2007.
