Results 1 to 8 of 8
  1. #1
    gar is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Nov 2011
    Posts
    42

    Read-only access

    I wanted to make a database available to a colleague but in read-only form. I tried to do this by sharing the .accdb file with him via OneDrive, unticking the "Allow editing" box in the process. He found, however, that he was able to edit the database though the changes he made did not appear when I looked at it later. The implication is that I have, in fact, created a second, independent copy of the database. Is there an alternative procedure which will enable me to achieve my desired end?

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    It is very difficult to make data tables read only (though it is possible).
    However, forms can easily be locked so they ar read only.

    Hence, what you should do is hide the navigation pane from end users so that all interaction is done using forms.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    call HideDb to remove user access to the tables.

    Code:
    Public Function HideDB()
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide
    End Function
    


  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Feel free to use my utility http://forestbyte.com/ms-access-utilities/fba-fuze/ that joins the latest front-end with the latest data every time it is opened (basically the opposite of the built in Access database splitting wizard). The end result is an all-in-one database that, while not a true "read-only", is totally disconnected from the live one. If you need an always live one to see the latest changes immediately this might not be the solution, but it does work well for certain tasks (i.e reporting/querying is much faster as all tables are local).

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    gar is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Nov 2011
    Posts
    42
    Quote Originally Posted by isladogs View Post
    It is very difficult to make data tables read only (though it is possible).
    However, forms can easily be locked so they ar read only.

    Hence, what you should do is hide the navigation pane from end users so that all interaction is done using forms.
    Thanks for your message. How do I lock a form and how do I hide the navigation pane from my colleague while keeping it visible for myself?

  6. #6
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Look through this guys youtube channel for his stuff on building a user login system as well as locking down the front end. He has several videos on the subject so look around.
    https://www.youtube.com/watch?v=i1n7H686bWI

    To lock a form down can be as easy as going to the form's properties and setting allow adds, deletions, edits to No.

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You can lock an entire form by opening in design view then setting Allow Additions/Allow Edits/Allow Deletions =No in the form property sheet.
    Alternatively use a read only query as the form's record source e.g. Using SELECT DISTINCT …

    You can set different options for various users using a login system where users are assigned login user levels
    For example, see http://www.mendipdatasystems.co.uk/p...gin/4594469149
    Last edited by isladogs; 03-18-2020 at 12:11 AM. Reason: Activated link
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #8
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Read Design & Read Data Issue
    By f15e in forum Access
    Replies: 7
    Last Post: 10-18-2016, 12:44 AM
  2. Read Access V2.0 using .Net
    By spc70 in forum Access
    Replies: 1
    Last Post: 09-03-2014, 06:59 AM
  3. Replies: 7
    Last Post: 07-19-2014, 05:54 AM
  4. Read only Access Database
    By Rameez in forum Access
    Replies: 7
    Last Post: 06-23-2009, 12:30 AM
  5. Replies: 2
    Last Post: 10-19-2006, 04:37 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