Table records weirdness

[Wally]

Hi there,
Please looking forward to get info about this one: a 2,000 rows Access
table lately cause underlying queries to freeze (Access Not
responding). So far the only way I found to unlock this is to cut a
bunch of last rows (like 30 or so no matter the number) from the
Access tbl, paste in Excel and paste again in the Access tbl; then
everything returns to normal, queries run fine again,...it looks like
a formatting problem but I never saw this before. The table can be
updated remotely thru web Cold Fusion (append or update record) but I
can 't see where and when the glitch happens. Never had this problem
before just lately. Table design is unchanged. Data looks fine. Does
someone already encountered this? Much appreciated thanks!

[Salad]

Wally wrote:

Hi there,
Please looking forward to get info about this one: a 2,000 rows Access
table lately cause underlying queries to freeze (Access Not
responding). So far the only way I found to unlock this is to cut a
bunch of last rows (like 30 or so no matter the number) from the
Access tbl, paste in Excel and paste again in the Access tbl; then
everything returns to normal, queries run fine again,...it looks like
a formatting problem but I never saw this before. The table can be
updated remotely thru web Cold Fusion (append or update record) but I
can 't see where and when the glitch happens. Never had this problem
before just lately. Table design is unchanged. Data looks fine. Does
someone already encountered this? Much appreciated thanks!

I haven't. Are you sure your data is correct? Maybe write a DAO
routine to scan thru each row and scan thru each column and assign the
value of each column to a variant. If it blows up, you know you have a
column with invalid data or a corrupt table.

[Wally]

On Sep 5, 3:43 pm, Salad <[e-mail]:

Wally wrote:

Hi there,
Please looking forward to get info about this one: a 2,000 rows Access
table lately cause underlying queries to freeze (Access Not
responding). So far the only way I found to unlock this is to cut a
bunch of last rows (like 30 or so no matter the number) from the
Access tbl, paste in Excel and paste again in the Access tbl; then
everything returns to normal, queries run fine again,...it looks like
a formatting problem but I never saw this before. The table can be
updated remotely thru web Cold Fusion (append or update record) but I
can 't see where and when the glitch happens. Never had this problem
before just lately. Table design is unchanged. Data looks fine. Does
someone already encountered this? Much appreciated thanks!

I haven't. Are you sure your data is correct? Maybe write a DAO
routine to scan thru each row and scan thru each column and assign the
value of each column to a variant. If it blows up, you know you have a
column with invalid data or a corrupt table.

Thanks for replying Salad. Data is corrupted indeed. I found
compacting is the cause or triggers the process. I have the solution
to repair the wrong records but after each compact the same table is
corrupted again. After repairing the table by cutting rows and
appending data from outside (sql from coldfusion or from Excel), user
appends row(s) in this table. Until compacting everything is fine with
those new records. After compacting, the table opens great but any
process using this table makes crash (Access Not Responding). Does
anyone can help? Thanks.