Save error in large table

[mbentley]

I have a table with 140 fields (I know, this is too many). I have a date field that intermittently will not allow data to be entered. There is a pattern to the data it will not accept, but it seems to only occur in certain records and what it will or will not allow seems different in each case. The error I get when I try to save a record is: The search key was not found in any record. I've isolated the error to the level of the table. Have tried compact/repair, removing the index on the field, deleting and recreating the field. Nothing works. Help!

 

[KenHigg]

Does it zonk when you try to edit other flds in these 'certain records'?

kh

 

[mbentley]

No, just that one field and only for certain entries. It's a date field, and only seems to accept dates that are sufficiently in the future for certain records. Very strange.

 

[KenHigg]

Have you tried to do a new mdb and import the table then see if it zonks as well?

kh

...accept dates that are sufficiently in the future

Perhaps if you wait long enough the dates will be valid
(Just kidding...)

 

[mbentley]

Tried that, but it didn't work. (The import thing...not the waiting thing )

Any other ideas?

 

[mbentley]

Just to add to that, I went in and deleted a bunch of fields. After that, it seems to work. Perhaps there's a limit of table sizes unrelated to the 255 maximum? We're on Windows NT, which seems to give Access fits once in a while. Perhaps that's related?