Results 1 to 2 of 2
  1. #1
    anindya is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    1

    Question Distributive user access to MS Access 2010 Forms.


    I've developed a small project in MS Access 2010 which contains about 7 forms and 8 tables.
    Now I want a distributive and concurrent user access for SOME OF THE FORMS where a specific form should be displayed to a specific user/set of users.
    There will also be some user privileges like read/write etc. but the information given by the users should be stored in some central location in terms of access table data only.
    Is there any way to implement this concept (may be using SharePoint or InfoPath) ?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    You could start by splitting the database. Place all of the tables in an accdb file on a central server. Use the file on the server as the Back End. Create Front End accdb files that contain only the necessary forms, reports, queries, and modules. Link the tables in the BE to the FE files and distributer the FE files to the users.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 11-18-2013, 02:20 PM
  2. Replies: 3
    Last Post: 10-31-2013, 02:36 PM
  3. ACCESS 2010 multi-user access
    By rustyroy in forum Access
    Replies: 9
    Last Post: 05-28-2013, 09:21 PM
  4. User permissions - access 2010
    By Outlook in forum Security
    Replies: 3
    Last Post: 12-03-2012, 08:19 AM
  5. Access 2007 db forms not working in Access 2010
    By Butterfly13 in forum Access
    Replies: 2
    Last Post: 09-07-2012, 12:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums