Autonumber field (Incremented change to Increment)

[Rommel]

I created a certain table called Product Costing, there
were only three (3) fields defined on it ID, Code and
Description. I'll just focus only the field ID which cause
me problem.

Field Data Type Field Size New Values
ID Autonumber Long Integer Increment

The problem is that when the database became a master
replica (replication was applied) then the New Values
property of the field ID was changed from Increment to
Random. And it causes me a trouble coz sometimes it will
give a negative value.

Can anyone tell me what's wrong? Can I fixed this problem
without recreating the table?

Regards.

 

[Jeff Boyce]

Rommel

Nothing is wrong. "Random" Autonumber uses both positive and negative
numbers. If you have been using the (autonumber) ID as a "user-viewable"
value, consider creating your own ID -- autonumbers are intended to be
unique (internal) row identifiers, and aren't particularly fit for human
consumption.

Good luck

Jeff Boyce
<Access MVP>