AutoNumber Alternative

[bkf7911]

I'm using an autonumber field in a table to generate the "Record #" for each record added to the form that uses that table. I'm getting corrupt records (chinese characters and/or boxes) about every week or so, and think this may have something to do with the auto-number field.

Is there a better way that "autonumber" to generate sequential identifiers with each record that is added?

 

[Remou]

Have a look here faq700-184 and here

http://www.granite.ab.ca/access/corruption/causes.htm