Distributed Data (1 Viewer)

[Randy253]

I was under the impression that if you split your database (front-end and back-end) you could have multiple users access the same database nad everything would update automatically. Maybe I am a little niave, but I am not finding that easy. I split a database and went over the network (peer to peer) and opened a the front end on two different machines. I can work in both, but they seem to be keeping the added records only in their own location. Even if I refresh the links (and I thought the data) they still do not show the other machines records. Am I missing something (obviously)? What else do I need to do? I understand if it is to complicated for this forum but at least I will know to look deeper. Thanks for any and all help.

 

[Travis]

Do they ever see the same records (New added from the other Front End)?

If not then they are not connected to the same Back-End.

 

[Autoeng]

The back end gets loaded onto a common directory on the server so everyone is working on the same data. The front end can be on the server as well or it can be loaded onto each person's machine. There are a lot of great posts on the subject.Do a search in the General area and you'll find tons of info.

Here are some that I have contributed to for a start.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37185

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37064

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37046

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36992

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36445

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=35554

Hope these help

Autoeng