Updating Main database from a laptop computer

[Guest]

I currently have a database that is located on a server that is shared to
multipal employees. We are getting laptop computers and are going to be
taken out on the field on where data will be enetered into the database on
the local hard drive. When we get back to the office and connect to the
network, how do we update the server database? And is it possible to update
the server database automatic?

I also dont have the database split (Unsure how to do this) but I do have
user accounts set up. (Office 2000)

Thanks
Detective Sebring
City of Snellville Police

 

[Douglas J. Steele]

What you need to look into is Replication.

See http://msdn.microsoft.com/library/en-us/dnacc2k/html/dbrepjet.asp and
http://support.microsoft.com/?id=282977 for more information.

You definitely need to split the database. See what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm for information about
this. When replicating, all you want to replicate is the data, not the
"application" (queries, forms, reports, macros and modules)

 

[Graham R Seach]

Kevin,

You seem to be a candidate for replication. Check Help for "replication",
and select "Create a replicated database", then read "Create a replica of
your database by using the menu bar".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia