I've had this problem in the past and found it to be a corrupt record in a
memo field. Luckily, there were not too many records and identified it
from
the query results. I then used the primary key from the query results to
create a delete query to remove the corrupt record.
Hope this helps,
Mark
"nimajneb via AccessMonster.com" <u42477@[EMAIL PROTECTED]
> wrote in message
news:840cbe7814204@[EMAIL PROTECTED]
> Can anyone offer me any insight on the following problem?
>
> I have an Access database on a company shared drive. I'm the designer
and
> the only user (so far). Suddenly, any time I try to open a table,
Access
> crashes... but if I look at that same data by *querying* the table
(SELECT
> *
> FROM [TableName]), everything works fine.
>
> Even though my data seems fine *for now*, it's a little scary for me.
> Insight? Possible solutions?
>
> --
> Message posted via http://www.accessmonster.com
>
|
