Multiple users

[bluwind]

Hi all, o.k prior to a previous message i have been back to my manager and informed him that there is no way of updating effectivly via email.

o.k first i will tell you what we will have:
Three networked pc's running xp prof, and access 2003.
Now what i want is to be able to have my database running as a server on one machine and have the two other machines running the same database simultaniously all of them updating.

Now what i need, i dont want to have the work done for me, just if someone could point me in the right direction, maybe one or two tutorials, any pitfalls i may find etc.

thanks in advance..

Rob

 

[gemma-the-husky]

no pitfalls really - that scenario is default access behaviour - however dont all use the same (networked) copy of the database

split the database so the data tables are on the server, and each user has there own copy of the code / modules etc. Look at front/end back end here for more info

 

[boblarson]

This should be good info for you:

http://www.members.shaw.ca/AlbertKallal/Articles/split/

 

[bluwind]

bob larson, wow thats a great help buddy, thats more than enough to be getting me along.
Successful completion of this project should earn me a managers position....