Lock Access DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,
In my project i am using access as backend & VisualBasic as front end i
would like to know how can i lock access db in back end so that no user cant
edit the tables in back end they should edit only from front end Visual Basic.

TIA
 
If the Access backend is pre Access 2007, you can use User Level Security
with a custom mdw Workgroup Information File and a Database Password to
secure the mdb.

You would have to have users login to your VB front end and then incorporate
the logon info and database password into the conection string you're using
to connect to the backend (assuming your using DAO or ADO).

Use a COPY of the standard System.mdw file to create your custom one and use
the Access built in Wizard (Tools>Security) to implement user level security
and try www.connectionstrings.com for help with the connection string.

HTH
 
Back
Top