Strange append/delete problem

  • Thread starter Thread starter DKode
  • Start date Start date
D

DKode

This is a very strange problem, i've tried to duplicate the problem
but I cannot get it to do the same thing. It is a night process that
is run by my company that does a series of make table queries to about
10 tables, only 1 table gets records appended.

For some reason when I run all of these queries the 1 table that gets
appened keeps losing records. for instance i'll have
11/1/2003-11/8/2003 records in the table, after a nightly processing
it will be missing days worth of records ~ 15,000 records from the
table even though NO delete query runs on this table. only one append
query.

does anyone have any idea why this would be happening and what else I
could do to try to replicate the problem so I can solve it?

any help would be greatly appreciated.

Thank you for your time

DKode
 
Just a thought:
I had a problem somewhat similar once. I was importing
data from a text file and no matter which way I tried it
kept losing some records. Later when I was trying to change
data in certain cells, the data expanded and I stumbled
upon the fact that somehow Access had merged 2 records
into 1. When I changed the table layout / row height, I
was able to see several instances where the data had been
merged - but with no rhyme or reason. I don't know if this
helps at all, but you can start there.
FYI: I was using Access 97 SR2.
 
Your problem might be caused by a "not so well" documented feature in Access: when you design a table and add a text field (or memo), the default value for the "Allow zero lenght" is set to No. Then when you run your action queries (append) all the records that are missing data (zero lenght) for that particular field are not added (you do not get a warning if your warnings are off). So the easy fix is to go and change the "Allow zero lenght" property to Yes for all the text/ memo fields in the target table.

Hope this helps!

Email:
v_cucinschi at hotmail dot com
 
Back
Top