Import/Export to remote laptop?

[Kevin]

To allow a user to work remotely (not on our network) with an Access 2002
database, I intend to replicate it. It is an estimating database and each
project has a ProjectID which is an AutoNumber field. This shouldn't be a
problem if an existing project is exported to the remote/laptop, but what
happens if the user adds a project on the laptop and a new ProjectID is
generated? Is there a way to update the ProjectID to the next available
number on the network database when it is exported back to the network? If
there is related records, will that data be safe if the ProjectID is changed?

Any feedback is appreciated!

 

[John Nurick]

I've never used Replication but as I understand it this problem doesn't
arise. Setting a database up for replication converts autonumber fields
from the standard Long data type to a much longer ReplicationID type,
with random values. For more information, see Help. When you have
specific questions, ask in the Replication newsgroup, where the experts
hang out.