Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2010

    Unanswered: how to create read-only access table

    Hi all;

    i need a help in how to create an access pivot table as readonly so as the records can not be edited.

    any help is appreciated.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    As far as I know there is no such thing as read-only tables in Access. You can use the security features (Tools --> Security --> Users & Groups) to prevent users from opening a table but this feature is obsolete in the newer versions of Access (Acc2007 and Acc2010).

    Users should never be allowed to have direct access to the tables anyway.
    Have a nice day!

  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    I believe a pivot table is actually a pivot table view of a Form, rather than an actual Table, as its name would seem to indicate!

    I've never worked with this particular creature before, but have you actually tried setting the Form's AllowEdits, AllowDeletions and AllowAdditions Properties to No/False? Or setting the RecordSet Type Property to Snapshot? Either approach should make the Form Read-Only.

    Let us hear back from you, whether it works or not. Inquiring minds want to know!

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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