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 04:01.
hope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON