Results 1 to 12 of 12
  1. #1
    Join Date
    Aug 2006
    Posts
    25

    Unanswered: How can I lock a database?

    I want to lock and archive a database in order for no one be able to use it, but have no coue on how to do it.

    Can anyone help please?

    Thanks,
    Comppal

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    You can't reaaly "lock up" per se any access db ... You can password protect it ... You can encrypt it ... You can (zip or otherwise) compact it up ...

    Give you some ideas????
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    or...

    Put it in a READ-ONLY folder
    Inspiration Through Fermentation

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by RedNeckGeek
    or...

    Put it in a READ-ONLY folder
    There's read only and then there's READ ONLY ... Just being RO doesn't prevent you from accessing data or manipulating data (adding, deleting, or changing), It prevents you from editing forms ,reports, or queries ... That's about it. You gotta go drastic to prevent ANY access whatsoever ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Maybe my test wasn't very thorough, but...

    I was not able to change data in a database that was read only.
    Inspiration Through Fermentation

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by RedNeckGeek
    Maybe my test wasn't very thorough, but...

    I was not able to change data in a database that was read only.
    I stand corrected (at least with A97) ... You can run SELECT queries (which by the way increases the size of the db ... so there is a change) but no edits of any kind otherwise ...
    Back to Access ... ADO is not the way to go for speed ...

  7. #7
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Probably lots of ways to do this. If I had a db I just wanted to put in "cold storage" and out of harms way, I'd place it in an obscure folder, or better yet, a sub folder, named so as not to give away the purpose, and change the extension of the db to something odd, like maybe HiddenDataBase.xxx. If someone comes snooping and clicks on the files, Windows will popup its "Open With" dialog box, and the snooper would then have to try each posibilty before hitting on MSAcess. I'd probably also put a password on the db as a backup measure.
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

  8. #8
    Join Date
    Aug 2006
    Posts
    25
    Thank you all for your help, M Owen, Red Neck Geek, and MissingLinq.
    I appreciate it greatly!

    CompPal

  9. #9
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Ship it off-site. That's the most sure fire way to address the issue, physical isolation.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  10. #10
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Or you could just delete it. Nobody would mess with it then!
    Inspiration Through Fermentation

  11. #11
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    reply

    Quote Originally Posted by comppal
    I want to lock and archive a database in order for no one be able to use it, but have no coue on how to do it.

    Can anyone help please?

    Thanks,
    Comppal
    It is very simple. Simply open the database in exclusive mode. Choose "Open Exclusive" when the open dialog box appears.
    No coding is needed.

  12. #12
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I was under the impression that Open Exclusive means that no one else can open the db when you already have it open, not that only you can open it. Am I wrong here?
    Hope this helps!

    The problem with making anything foolproof...is 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
  •