free tracking

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.

I have not seen any other mention of this problem and would be very interested in anyone that could shed some light on why this is the case and how it could be handled more appropriately. It becomes a real pain to put new programs online when you always have to open and modify a form to maintain the system performance.

Spread the word

del.icio.us Digg Furl Reddit Help

Permalink • Print

Related Entries

Made with WordPress and a search engine optimized WordPress theme • Sky Gold skin by Denis de Bernardy