I have a database at our main depot that I want to be accessed from other 
depots - the problem with this is the speed over a network - does anyone 
know if is possible to copy a table/tables from the main database to one 
at the remote site - then be able to add records to both and then merge 
both into one table again 
Thanks for any help
Peter

Hi Peter
this might be a suitable candidate for replication, go to Access Help and do a search for
replication.  I have been researching this same technique for Internet Synchronisation which you can
see in the above post as of 20/8/02.   However you won't need Office Developer to use this facility.

Best of luck
Oliver Dempsey


----- Original Message -----
From: "peter pennells" <ppenn@b...>
To: "Access" <access@p...>
Sent: Wednesday, August 21, 2002 11:26 AM
Subject: [access] Access over network


> I have a database at our main depot that I want to be accessed from other
> depots - the problem with this is the speed over a network - does anyone
> know if is possible to copy a table/tables from the main database to one
> at the remote site - then be able to add records to both and then merge
> both into one table again
> Thanks for any help
> Peter
>

What you're talking about here is replication. There's heaps of info about it on the web, 
including the Microsoft site and this one. However, if you really want to know the full ins and 
outs of it, I suggest looking into "Access 2000 Developer's Handbook - Volume 2: Enterprise 
Edition" - Chapter 9 is devoted entirely to the subject. It's a fairly expensive book, (so you 
might want to get your company to pay for it) but it's the best around - most other books just 
have one or two paragraphs on replication, sating that it exists, but not much else.

The microsoft site has good info too, for example:
http://msdn.microsoft.com/library/techart/dbrepjet.htm

There's entire newsgroups and sites dedicated explicitly on the subject, so I'd suggest trolling 
through some of them too. 

It's possibly one of the trickiest things Access can do - but also one of the coolest.

Steven

I would ask, what is wrong with your network?  Are you using something
really slow like dial-up networking?  Because there really shouldn't be any
performance issues caused by your network unless it is a very unusual
network setup.  Is this a theoretical concern or do you have some actual
performance problems in practice?


Some other questions you should find answers to : 
how much data are you sending over the network when your system is used?
You may be able to identify data transfer bottlenecks...
Is Access installed on the client machine, and the MDB data file available
on the network?  if the users are executing a copy of Access that is also
remote then this can cause some slowdowns.

You can do what you ask but it is MUCH easier to fix the performance problem
with your network.

-----Original Message-----
From: peter pennells [mailto:ppenn@b...]
Sent: Wednesday, August 21, 2002 6:26 AM
To: Access
Subject: [access] Access over network


I have a database at our main depot that I want to be accessed from other 
depots - the problem with this is the speed over a network - does anyone 
know if is possible to copy a table/tables from the main database to one 
at the remote site - then be able to add records to both and then merge 
both into one table again 
Thanks for any help
Peter