multi user "jomara via AccessMonster.com" <u27274[ at ]uwe> 29.09.2006 15:09:10 i have 5 sales people using an access database on there local machines i want to split the database and combine the backends on the server . i also need to create security so they cannot see each others records. is this possible or should i split the database keep in local on there machines and then how would i combine their backends to 1 master file to run my reports. I am not very familier with access -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1

Re: multi user "Lynn Trapp" <NOltrapp[ at ]SPAMltcomputerdesigns.com> 29.09.2006 17:29:32 You would need to implement replication for your database. You should pose your question on microsoft.public.access.replication -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "jomara via AccessMonster.com" <u27274[ at ]uwe> wrote in message news:670536e5fbce7[ at ]uwe... [Quoted Text] >i have 5 sales people using an access database on there local machines i >want > to split the database and combine the backends on the server . i also > need > to create security so they cannot see each others records. is this > possible > or should i split the database keep in local on there machines and then > how > would i combine their backends to 1 master file to run my reports. I am > not > very familier with access > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1 >