Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / August 2003

Tip: Looking for answers? Try searching our database.

updating data from multiple laptops?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Randy - 26 Aug 2003 04:17 GMT
I have an access 2000 program in my office.  I have the identical program on
6 laptops in the field.  I need to figure out a way to update, syncronize or
append the data from the laptops to the master database in the office.  The
laptops are not linked in any way.  I have tried to export data from the
laptops to an excel file on a floppy disk and then importing the data to the
main database.  This usually doesn't work.  I get key violations and
incorrect formats.  Is there another way for me to do this?  I really need
help...Thanks...Randy
HSalim - 26 Aug 2003 05:42 GMT
What you need is Merge Replication.  This is a complicated subject.  There
are many critical areas in database design and application design to
implement this.
You might be better off moving to SQL server and taking advantage of its
Merge Replication abilities,
and you should definitely invest in a book that covers this subject in
detail.

HS

> I have an access 2000 program in my office.  I have the identical program on
> 6 laptops in the field.  I need to figure out a way to update, syncronize or
[quoted text clipped - 4 lines]
> incorrect formats.  Is there another way for me to do this?  I really need
> help...Thanks...Randy
Tony Toews - 28 Aug 2003 00:12 GMT
>What you need is Merge Replication.  This is a complicated subject.  There
>are many critical areas in database design and application design to
>implement this.
>You might be better off moving to SQL server and taking advantage of its
>Merge Replication abilities,

Eh?  Access has replication built in.  Granted it likely isn't a
robust or feature rich but it does exist.   How is SQL Server
replication superior?   And is it worth the extra time and effort?

Tony
--
Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
HSalim - 28 Aug 2003 14:27 GMT
Tony,
You are right of course.  I had forgotten that Access has support for
replication.
HS

> >What you need is Merge Replication.  This is a complicated subject.  There
> >are many critical areas in database design and application design to
[quoted text clipped - 13 lines]
>    Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
Frank Konzal - 26 Aug 2003 11:52 GMT
I don't know if this will help , not knowing the size of the datafile you are
trying to transport, but text files zip down tremendously and could be
transported by diskette or wireless with little time involved.  One of the
methods we use is to create the text file with table names, field names and
data.
Example
[tblPersons]
LastName="Smith"
FirstName="John"

Brackets indicate table name

The added advantage is that null fields don't have to be transported saving more
space.  A simple import routine on the main database can open the text file and
import the data.

> I have an access 2000 program in my office.  I have the identical program on
> 6 laptops in the field.  I need to figure out a way to update, syncronize or
[quoted text clipped - 4 lines]
> incorrect formats.  Is there another way for me to do this?  I really need
> help...Thanks...Randy
Ian Claridge - 26 Aug 2003 13:01 GMT
If the data you want to update is additions to the
database (new contacts new companies new projects new
quotes) then this can be done simply by email.

I operate a similar system for my company where each
laptop has a blank "updates" database in addition to
the "copy" of the office database.

Then, each time an addition is made to a table (Each
record should be set to have a key and this should be
generated randomly to ensure that each addition is not
confused), the daabase runs a "make table" query that
makes a table in the updates database containing only the
new record.  This table is emailed to the office
whereupon it can simply be appended to the corresponding
table in the "master database".

i have further enhanced our system to include the append
queries in the updates database (so that the office
receives an application that they open and press the
correct button to make the update) and at the sender's
end the table is automatically deleted after sending.

If all parties email the update to all others at the same
time as sending to head office then information can
be "shared".

A harder task is to make this system work for amendments
(i.e. changes to records).  If you can accept that
the "update" is always superior to the existing record
(i.e. the senders copy does not conflict with the
recipient's) you can add the functionality of sending the
update in the same way but if the recipient already has
that record ID, it automatically deletes it and then
appends the update.

I know this sounds complicated but it's quite simple once
you take a look more closely (I can send u my code if you
desire).

the belt and braces solution (if i am not mistaken) is to
purchase office developer edition that allows database
replication over the internet, or you could create
perhaps a front/back end database over a virtual private
network.  I suspect with 6 laptops you will be looking
like me at a more economic solution!

Hope this helps

>-----Original Message-----
>I don't know if this will help , not knowing the size of the datafile you are
[quoted text clipped - 21 lines]
>> incorrect formats.  Is there another way for me to do this?  I really need
>> help...Thanks...Randy
Joan Wild - 26 Aug 2003 15:44 GMT
This is what replication was designed for.

See
http://support.microsoft.com/?id=190766 - white paper
http://support.microsoft.com/?id=282977 - FAQ

Also see
www.trigeminal.com - excellent replication site
http://support.microsoft.com/support/access/content/repl/replication.asp

These should give you enough information to set up replication.  If you have
further questions, I suggest you ask in the
microsoft.public.access.replication group.

Signature

Joan Wild
Microsoft Access MVP

> I have an access 2000 program in my office.  I have the identical program on
> 6 laptops in the field.  I need to figure out a way to update, syncronize or
[quoted text clipped - 4 lines]
> incorrect formats.  Is there another way for me to do this?  I really need
> help...Thanks...Randy
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.