Results 1 to 11 of 11

Thread: multiple users

  1. #1
    Join Date
    Oct 2004
    Posts
    57

    Unanswered: multiple users

    i have a database that resides on a network drive. is there anthing i need to setup if i'm going to have multiple users that will add and edit records from the same table through a form at the same time?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Geremia
    i have a database that resides on a network drive. is there anthing i need to setup if i'm going to have multiple users that will add and edit records from the same table through a form at the same time?
    Uh .... Yeah. A different way of doing it. Data entry in Access using a form bound to the actual data table is not multi-user capable ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Oct 2004
    Posts
    57
    Great...I'm guessing an unbound form??

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Geremia
    Great...I'm guessing an unbound form??
    Why would you guess that? Having an unbound form would work for somethings ... You'd have to code the save/update operations to the table(s) ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Oct 2004
    Posts
    57
    any other ideas....im open to suggestions...

  6. #6
    Join Date
    May 2004
    Posts
    73
    Use an SQL server. It handles multiple users and file locking capabilities. Expensive tho. You could write the program to work with MySQL (which is free)/

  7. #7
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I am a little confused by the responses you have gotten so far. Do you have an Access database? One file with tables and forms in it that is on the server? If so then you might consider splitting the database. Put the tables of the database in one Access DB file and the forms, reports, queries in another. The tables would be your backend database and the other database is the frontend. You can then 'distribute' the frontend on user computers and connect them to the backend database using linked tables. Even if you don't do that, the database should be multi-user (assuming it is Access).

  8. #8
    Join Date
    Oct 2004
    Posts
    57
    thanks dckunkle (and everyone else) ill try that setup....

  9. #9
    Join Date
    Nov 2004
    Posts
    3
    Am I the only one who uses replicas and synchronization?

  10. #10
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113
    DCKnukle,
    I am curious myself. Your saying that doing an Get external Data - Table link will allow multiple users to add, delete and change data. That simple. Learning Access so, so sorry if the question seems so novice.

  11. #11
    Join Date
    Apr 2004
    Posts
    41
    Quote Originally Posted by M Owen
    Uh .... Yeah. A different way of doing it. Data entry in Access using a form bound to the actual data table is not multi-user capable ...
    Could you elaborate on this?

Posting Permissions

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