Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: sharing my database

    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?

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    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

    StePhan McKillen
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts