X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Replication and Random Records    
post Mar 30 2006, 02:34 PM

Posts: 1
Joined: 30-March 06

I had the autonumber property for my records set to increment. after replicating the database the property was changed to random. is there any way to keep the property set to increment.? otherwise, is there a way to do this in a multi user environment without replicating.?
Go to the top of the page
post Mar 30 2006, 03:51 PM

Posts: 585
Joined: 28-December 01
From: Southwest, MO, USA

You don't need to use replication for Access to work in a multi-user environment. If you are running on a LAN, search for spliting a database into a Front End (FE) and Back End (BE).
ow, if you truly need replication, I created a two field key. The first field being a long integer, that I increment myself and the second field is a plant number. That way, when I synchronize the databases, everything is keyed correctly.
I hope this helps.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    18th January 2020 - 10:04 AM