We have a report that links two (2) paradox tables by what is supposed to be a common field, a 4-digit card number (acces control software). It seems, that by magic, the table design for one of the fields is now an AutoNumber. Now the report will not work. This report has ran OK for a few years now it is broken.
If there a way to repair the table and fix the table design from Auto Number to Double or Long Integer format?
Any 3rd party software available?