How do I UNDO the replica in MS Access?

[Guest]

I made a replica of my MS access database. But, it didn't occured to me that
the autonumber becomes "random" instead of "increment." I need to undo the
replica and put the database back to normal. Is there any way of doing that?

 

[DLG]

Michael Kaplan has a tool for this at www.trigeminal.com

 

[Douglas J Steele]

No, there's no way.

However, why does it matter? Autonumbers exist for one purpose: to provide a
(practically guaranteed) unique value that can be used as a primary key.
34643, -542667, 1646477 serves that purpose just as well as 4, 5, 7.

No meaning should ever be assigned to an Autonumber. In fact, it's normal
not to even let the users see the value of the Autonumber field. If the
value of an Autonumber field matters to you, odds are you shouldn't be using
an Autonumber field.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I made a replica of my MS access database. But, it didn't occured to me that
the autonumber becomes "random" instead of "increment." I need to undo the
replica and put the database back to normal. Is there any way of doing

that?

 

[Douglas J Steele]

You sure that switches the Autonumbers from Random back to Increment?