December 2, 2008
MS Access problems between 2003 and 2002
I have a large database application that is ran on 25 client computers accessing a MS SQL database back end.
This works out pretty well however I have found a little incompatiablity between version 2002 and 2003 and/or the setup between my machine and the clients computer.
The main issue seems to be with the speed in loading the forms with lots of controls.
We have one main table that contains all the orders and the related form contains 514 controls (yes a large number but it’s a client requirement as it is right now). I do most of my development on Access 2003 and then transfer the client’s computer which has Access 2002.
The form becomes very slow to load when I transfer the database to the 2002 computer. I have found that if I open the form in the design mode, change the filter from Orderid=0 to OrderID=-1 and save the changes the system speed returns.
