Re: Access DB LockDown?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Leave Access to control who can do what.
Create User Level Security, then your VB app connects with the only account.

This should get you started:
http://databases.about.com/od/tutorials/ss/usersecurity.htm

NickHK


"AK" <nospam@xxxxxxx> wrote in message
news:_WImg.22944$vU.10083@xxxxxxxxxxxxxxxxxxxxxxx
Maybe OT

Our concept VB6 app reads and writes to a MS Access database. We need to
somehow put a firewall/shield around the database so that only our app can
access it. Can someowe point me in the the right direction for doing this.
While we want users of the software to be able to utilize our apps read
and
write capabilities, we don't want them viewing the database itself. Right
now all then have to do is find the mdb file and if they have access on
their system open the database. Is this a VB6 techniqu or a function of
Access.




AK




.

Relevant Pages

  • Re: Access 2003: Thinking about going multiuser with user security,...
    ... you're going to want some modules in the app that run on startup. ... This is especially important with regard to disabling the bypass key. ... Read through some tutorials about User Level Security and walk through the ULS Wizard a bunch of times. ...
    (comp.databases.ms-access)
  • Re: Access DB LockDown?
    ... Our concept VB6 app reads and writes to a MS Access database. ... somehow put a firewall/shield around the database so that only our app can ...
    (microsoft.public.vb.general.discussion)
  • Access DB LockDown?
    ... Our concept VB6 app reads and writes to a MS Access database. ... somehow put a firewall/shield around the database so that only our app can ...
    (microsoft.public.vb.general.discussion)
  • Re: authentication Mode
    ... Consider using an Application Role rather than user level security. ... Most good judgment comes from experience. ... This app must allow for two login scenarios other than the usual one ... using a machine running under a different users login. ...
    (microsoft.public.sqlserver.security)
  • Re: Access DB LockDown?
    ... ¤ Our concept VB6 app reads and writes to a MS Access database. ...
    (microsoft.public.vb.general.discussion)