Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    157

    Unanswered: databse to readonly thru code

    Hi: How do i change the whole databse to readonly thru code.

    Thanks.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Not sure that you can, but you can make any form read only with:

    Code:
    Private Sub Form_Load()
       Me.AllowAdditions = False
       Me.AllowDeletions = False
       Me.AllowEdits = False
    End Sub
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Set the ReadOnly attribute of the file. Should be able to do it thru the FSO ... Now, you'll not be able to do this while the file is being used ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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