Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unanswered: Hhow to SECURE an Access Project ?

    What is the best way to SECURE an Access Project (ADP) ?
    The back-end of my ADP application is an SQL Server 2000 database.

    I merely relied on Windows authentication on the back-end.
    I also added code on the front-end to make sure the front-end will run on 2 computers.

    Is this enough ?

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    If it's an ADP, SQL Server permissions to the table(s) are usually enough. I'm not sure what code you added to make sure the front-end will run on 2 computers but you can usually do this without adding in extra code. If you want to add in additional security, you can check out the getuser() permissions in the code bank which shows you another method based on a "security" table. You can even get into using Access security to the ADP itself. Many different ways to impliment security.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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