Results 1 to 3 of 3
  1. #1
    praloy is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012

    Open Access Database in Read Only Mode

    Hi Team,

    I have not been able to figure, if we have the option to open the database as read-only using VBA in Access. Example Workbooks.Open Filename:="D:\Files\ABC.XLS", ReadOnly:=True

    Regards and thanks in Advance.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    I don't think so. Can hide navigation pane, disable ribbon and toolbars, manage forms so that data is not editable on them, create an accde. Review this for a start
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    praloy is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Thank you for responding and for the link....This has to be limitation of Access VBA then...the only solution for making read only is by Setting Attribute of a file to VBReadonly, and it does not give much control.

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

Similar Threads

  1. Replies: 2
    Last Post: 09-01-2011, 10:48 PM
  2. C program: read/write Access database
    By serendipity1276 in forum Programming
    Replies: 1
    Last Post: 08-15-2011, 01:15 PM
  3. Replies: 7
    Last Post: 03-22-2011, 10:36 AM
  4. can a access database table be read-only?
    By princess-1 in forum Access
    Replies: 5
    Last Post: 10-24-2010, 07:52 PM
  5. Read only Access Database
    By Rameez in forum Access
    Replies: 7
    Last Post: 06-23-2009, 12:30 AM

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