I take it this is NOT a query against a table... just a straight double click on a
table to open it.
Something in the table design is approaching a text field as a number or vice versa, or
it could be corrupt.
First, compact and repair the database.
Next, in table design mode, remove any formatting, validation rules, inputmasks, etc...
anything other than just the field type and length.
If you still have the problem, then make a copy of the table under another name, and
delete one field from that table, and test to see if the problem goes away. Repeat,Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13305
deleting a field each time. That should pin it down.
Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions
"Rich D" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13305
> When I try to open one of my tables in Table View", I get the above message.
> How do I locate where the problem is. I've even tried to reconstruct the
> table,but the problem persists.
> Rich D
> Armstrong Custom Homes