Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Share Access on a Network (Access 2000)

    Is it very difficult to set up Access 2000 on a network drive so that more than 1 person can use it? Do you just set up permissions?
    Thank you in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Share Access on a Network (Access 2000)

    Do you mean shared use of the Access application, or of an Access database?

  3. #3
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Share Access on a Network (Access 2000)

    I think it would be the database. It is being used by 1 user right now. It is going to be placed on a network drive so that 3 people can access it. It is just a regular Access 2000 database (tables, forms and reports).
    Thanks Hans.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Share Access on a Network (Access 2000)

    Ah, OK. Access is multi-user by default, so if you place the database in a shared network folder, several users can work with it at the same time.

    I strongly recommend that you split the database into a backend containing only the tables, and a frontend containing all other database objects, plus links to the tables in the backend. Place the backend in a shared network folder, and give each user an individual copy of the frontend. The frontend can be stored on the user's hard disk, or on a network folder. The user needs to have modify permissions (read/write/create/delete) on both the folder containing the frontend and on the folder containing the backend.

    See WendellB's tutorial Why Split a Database? for some background.

Posting Permissions

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