P
Pejo
I'm having a problem with firewall hiccups that sometime cause
duplicate rows to be written to the database.
I wanted to constrict the table to not allow duplicates but I'm being told
that
it may cause our web users to get an error message which is something we
want to avoid.
So as a solution I need to write a query that will go through and find the
duplicates and delete all but one of them. Unfortunately there are no
unique Identifiers on this table and therefore the records are exactly
identical which I presume will make it harder to do this. They are date
stamped but this is done by asp code and when they go in they all go in at
the same time. I had a problem like this with SQL Server before but the
datestamp showed them seconds apart so I just searched for a Max...I'm
clueless on how to approach this one especially since I am just becoming
acquainted with Access..
Can anyone help me out here or point me to a resource.
Thanks in advance.
Cheers.
duplicate rows to be written to the database.
I wanted to constrict the table to not allow duplicates but I'm being told
that
it may cause our web users to get an error message which is something we
want to avoid.
So as a solution I need to write a query that will go through and find the
duplicates and delete all but one of them. Unfortunately there are no
unique Identifiers on this table and therefore the records are exactly
identical which I presume will make it harder to do this. They are date
stamped but this is done by asp code and when they go in they all go in at
the same time. I had a problem like this with SQL Server before but the
datestamp showed them seconds apart so I just searched for a Max...I'm
clueless on how to approach this one especially since I am just becoming
acquainted with Access..
Can anyone help me out here or point me to a resource.
Thanks in advance.
Cheers.