[AccessD] Autonumber in replication

What max number of users do you all think is advisable in a single BE/ 
multi-FE set up? I may have to roll something out on a temporary basis until 
the new and improved, replicated version is ready. Or who knows, they may 
want to use SQLServer BE. I will know better tomorrow, which is kind of 
funny when you think about it....I never seem to know better..ever.
_D

"Things are only free to the extent that you don't pay for them".-Don 
Elliker





>From: "Wortz, Charles" <CWortz at tea.state.tx.us>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Autonumber in replication
>Date: Wed, 13 Aug 2003 15:15:17 -0500
>
>Don,
>
>Each of the FEs will need a local table holding the next available
>sequence number for that FE that you then append to a unique id for that
>FE and send that along to the BE as the test case number and show to the
>user.  So Bubba's test cases would be BUBB0001, BUBB0002, etc. while
>John's would be JOHN001, JOHN0002, etc.
>
>Charles Wortz
>Software Development Division
>Texas Education Agency
>1701 N. Congress Ave
>Austin, TX 78701-1494
>512-463-9493
>CWortz at tea.state.tx.us
>
>
>
>-----Original Message-----
>From: Don Elliker [mailto:delliker at hotmail.com]
>Sent: Wednesday 2003 Aug 13 15:03
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] Autonumber in replication
>
>Yes. I just found some info on this in the 2K/ADH - Vol2 page 472. Looks
>
>like a custom assignment of this value is in the wings as JET changes
>the
>assignment from sequential to random. Not good for my purposes....I can
>just
>see my users face when their new test case is number 1,956,000,045. Come
>to
>think of it, I WOULD like to see their face...And don't yell at me about
>
>using autonumber in a visible way,etc. etc....I didn't do that part, it
>was
>already like that when I got here..(yeah, sure it was buddy)...anywho,
>thanks
>_d
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963