multiple users - some remote

[Tal]

I have created a database that will be used by multiple people. Problem is,
all users won't at all times be on the local netwok so I need to find a way
to make it possible for someone to update the database remotely (can't
afford to set up on online database - our webhost doesn't do microsoft)

Our situation: we have a main office with 5 computers networked. We have
3 sales people. only one of those sales people is able to regularly update
the database in our main office. The others can update on a standalone
computer (eg, at home or at our other small office) but I need to be able to
synchronise all the databases together from time to time.

What's the best way to approach this?

Thanks

 

[Van T. Dinh]

Check Access Help / Access books on replication.

HTH
Van T. Dinh
MVP (Access)

 

[Tal]

-- > Check Access Help / Access books on replication.


I've tried creating replicas, but it seems you have to be connected for the
network for it to work.....when we copied a replica that had been updated
OFF the network back onto the network and tried to synchronise, it didn't
work, anything updated while connected to the network however was fine.

 

[Van T. Dinh]

In my case, it is fairly simple as the Sales Reps do updates on their
replicas. Once every few days, they some in to the office, connect their
laptops to the network and synchronise without any problem. In fact, I
would have a hard time fixing it if there is any problem because from the
time I set it up until now, it has always worked perfectly so I don't have
any experience fixing replication problems.

However, I can't see why copying the file would make any difference except
perhaps you need to point the replicates to the master location. Few things
you can do:

* There is a fairly comprehensive Replication white paper on Microsoft Web
site. Try to get a copy a see if it helps.

* Re-post your question to the replication newsgroup. MichKa would know
more about replication than anyone else and he frequents that newsgroup
regularly.