[AccessD] Multiple Users Question - Replicated Database

Hi Bill,

Thank you for your response.  Do you use the synchmanager on the pda to
synch the two devices?  

Julie Reardon
PRO-SOFT of NY, Inc.
44 Public Square, Suite 5
Watertown, NY  13601
Phone:  315.785.0319
Fax:  315.785.0323
NYS IT Contract#CMT026A
NYS Certified Woman-Owned Business
www.pro-soft.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten
Sent: Thursday, September 13, 2007 2:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Multiple Users Question - Replicated Database

Hi Julie,

Several years ago I upsized a synchronized Access database into sql server. 
The upsizing wizard created a trigger that used the similar code to this. I 
use this in a VB.NET PDA to create new ID's when ever I add a record and to 
date have never had a duplicate record created. Probably not as good as a 
GUID,  but certainly much easier to read ID's when troubleshooting.

Bill

Turn off autonumber and use this function to create the 'Random' ID

newid = fncNewID()

Public Function fncNewID() As Long
    ' This function creates an ID similar to that created by Access 
synchronize ID
    ' and emulated by a trigger in SQL server 2000
    Randomize()
    fncNewID = Int((100000000 + 100000000 + 1) * Rnd() - 100000000)
  End Function



----- Original Message ----- 
From: "Julie Reardon" <prosoft6 at hotmail.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, September 13, 2007 10:45 AM
Subject: [AccessD] Multiple Users Question - Replicated Database


Hi,

I am kind of stuck on an issue and wondered if anyone has done this.

My housing inspection software is being used locally and is working great.

However, when I wrote the software, they were only using one tablet pc and
replicating with the master copy on the server.

Now they want to send multiple inspectors out there with tablet pc's.

My problem is that when they create an inspection, I assign a unique
inspection id.  That id follows the record through the inspection process,
and then onto the Work Order that is created when there are repairs needed.

If I have multiple inspectors with tablet pc's, I can't create the unique
inspection id (automatically increments by one) when the inspection is
created on the tablet pc, because I won't know which id each of the tablet
pc's are using until the users synch with the copy on the server.

Multiple inspectors means duplicate inspection id's.

Is this making sense?

I need a way to create a temporary inspection id that is unique and then
when the inspector synchs with the server, a permanent id is assigned to the
record.

Anyone run into this?

Is this the way to go about doing this?

I'm not necessarily looking for code, just some opinions.

Julie Reardon
PRO-SOFT of NY, Inc.
44 Public Square, Suite 5
Watertown, NY  13601
Phone:  315.785.0319
Fax:  315.785.0323
NYS IT Contract#CMT026A
NYS Certified Woman-Owned Business
www.pro-soft.net


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com