I write a new version of my VB6 application which write data in Access database. Now I use file format Access 2002-2003 with MDAC 2.8 under XP and Win 7. For now it prove that work stable and I’m happy. The application currently work in many (more than 50 computers) since last 3 years.
My DV have about 30 tables , 10 querys and not many record, middle size 30-40 MB.
Rarely I get problem when power off suddenly, the DB file can be broken but usually Compact DB fix this.
So my question is – should I go to Access 2007 file format? I use only tables and few queries, no transaction at all. There only 1 limits in Access 2003 – I need text fields with let say 1024 symbol with Index features (I will search on it with Like command). With Access 2003 I have only 255 symbols.
Please share you experience. Do you have problem with migration and does new 2007 format is stable as old 2003?