Ashfaque
Search Beautiful Girls from your town for night
- Local time
- Today, 08:26
- Joined
- Sep 6, 2004
- Messages
- 897
Hi,
I have a table SSR (Sample Supply Request) with around 10,000 records. Let us say it has following 4 fields along with their field types.
A -Date
B -Text
C -Number
D -Memo
E -Yes/No
Due to the write-confilict, it stored one of the records as error, error, error in each field of recordset.
Let us say this error replaced record no. 5530. Rest records are ok.
The problem is who ever user reach to this table through forms, it produced error "Invalid Arguments" and stop doing nothing.
To come over this problem, I open the table itself I do copy structure of the table to create a new table. Then copy (manually) preceding 5529 records leaving record # 5530 and then rest of the records to the new table. Later on I do delete the infected table and rename the new one to its old name preserving relationship. But I am fed-up doing this.
Although its a matter of little time to spend doing this but I believe it is not the correct way.
Can anyone tell me if there is any kind query I can write to copy all records except the damaged one to the new table?
Suggestions are welcome....
With kind regards,
Ashfaque
I have a table SSR (Sample Supply Request) with around 10,000 records. Let us say it has following 4 fields along with their field types.
A -Date
B -Text
C -Number
D -Memo
E -Yes/No
Due to the write-confilict, it stored one of the records as error, error, error in each field of recordset.
Let us say this error replaced record no. 5530. Rest records are ok.
The problem is who ever user reach to this table through forms, it produced error "Invalid Arguments" and stop doing nothing.
To come over this problem, I open the table itself I do copy structure of the table to create a new table. Then copy (manually) preceding 5529 records leaving record # 5530 and then rest of the records to the new table. Later on I do delete the infected table and rename the new one to its old name preserving relationship. But I am fed-up doing this.
Although its a matter of little time to spend doing this but I believe it is not the correct way.
Can anyone tell me if there is any kind query I can write to copy all records except the damaged one to the new table?
Suggestions are welcome....
With kind regards,
Ashfaque