how can I Apply my DataBase to over 10 users/computers with out using shared folder, now my database .mdb file is on a shared folder called DB on the company server and the users access to the DataBase via this shared folder(client / server) is the are other ways to provide my dataBase to users?
Split the database so you get a backend (data) front end (the screen every thing else)
what I do on the server I create a folder call data and share it with a $ this will make it hidden on the server give every read/write access as well.
on the in the front end relink the tables so it point to
so What I do is copy the front end to the server under the folder call screens this come you backup copy
now need to set at each computer and copy the front to a folder on the user computer again I make it screen folder keeps everything tidy
create short cut on desktop job done
only down side is when you have to update the screens (front ends) you have to visit all the user computers
but there is a work around is what i have done is create a batch file that copy the front end the user computer @ startup
then I know that @ the next reboot they get the lateest version on there PC.
Last edited by myle; 06-05-06 at 05:01.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.