Row checksum in Access?

  • Thread starter Thread starter helot
  • Start date Start date
H

helot

Is there any way in Access to create a row checksum, in the same manner
as on SQL Server (checksum() function) ?
I need to compare rows between two databases, which have some fields as
BinaryLong.

Any idea what would be the best approach ?

I have already written a script in Python that does row-to-row compare
and then use a native object (proprietary GIS software) to get the
binary data comaprison, but the speed is really really slow ( 5 records
/sec, each of 30 tables has about 50,000 records).

thanks for any hint !
 
Hi


What about exporting the data into a text file, from both databases, and
computing a hash() number of these. Two identical text files would have the
same hash() code, necessary? That technique is involved to assert that the
content of a file has not been altered.

Note that this solution also assumes the order of the row can be easily
reproduced (else your text files could differ by inversion of rows
position,while the data, in its whole, is the same).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top