G
Geoff tenOever
Guest
I have developed a Tax Assessment solution using Access 2003, I already have in excess of 150k records, I have 7 tables; 55 queries; 30 forms.
My main table "Transact" has over 175 fields (yep I know its large, but I need all these fields and dont want to create 100's of tables). Since last week I cannot save any definition changes to my table, I keep receiving error 3309. I have searched all discussion groups but cannot find any decent solution.
1. I have not changed the index's, of no duplicates
2. I do not have more than 255 columns in table
3. I have increased the maxlocks substantially
4. run a compact & repair succesfully
What else can I try, as mentioend I am reluctant to split Transact into smaller tables.
Regards
Gto
My main table "Transact" has over 175 fields (yep I know its large, but I need all these fields and dont want to create 100's of tables). Since last week I cannot save any definition changes to my table, I keep receiving error 3309. I have searched all discussion groups but cannot find any decent solution.
1. I have not changed the index's, of no duplicates
2. I do not have more than 255 columns in table
3. I have increased the maxlocks substantially
4. run a compact & repair succesfully
What else can I try, as mentioend I am reluctant to split Transact into smaller tables.
Regards
Gto