Secure a Back-End DB in a Split DB

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Tony_VBACoder (anonymous_at_discussions.microsoft.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 07:15:12 -0700

I have split my Access 2002 database into a FrontEnd and
BackEnd database. I have successfully implemented user
security to the FrontEnd Database by the use of a MDW file
and everything works great. I have created an icon which
the user clicks on to launch the database, which has the
full path to the FrontEnd database and the Workgroup file.

I also need to apply security to the BackEnd database,
which has all the tables in it - the FrontEnd database has
all the Forms/Queries/Reports and links to the tables in
the BackEnd database.

What is the best method that I should take to secure my
BackEnd database? I have not found much information in
any FAQ that relates to securing the BackEnd, though I
have found lots talking about securing the FrontEnd.
Also, how will securing both my BackEnd database and
FrontEnd database effect how my users should log into the
FrontEnd database?

Relevant Pages

  • Re: Secure a Back-End DB in a Split DB
    ... With regards to the BackEnd database and trying to prevent ... should not affect FrontEnd database access, ... >> What is the best method that I should take to secure my ...
    (microsoft.public.access.security)
  • Re: front-end/back-end
    ... tblReports -> table of all the reports used in the application ... >> it's the standard setup for a multi-user database. ... the frontend database is ...
    (microsoft.public.access.gettingstarted)
  • Re: Transfering databases
    ... be able to open up another database from one I already have open. ... Lisa S. ... you don't put tables in a frontend database at all. ... Dim app As Access.Application ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Closing down a session
    ... backend database with one record. ... In the frontend database -- the one that each user uses, ... I then created a macro, ...
    (microsoft.public.access.gettingstarted)
  • Re: front-end/back-end
    ... > it's the standard setup for a multi-user database. ... the backend database ... > contains all the data tables, and is stored on the server. ... > frontend database contains the queries, forms, macros, reports and modules ...
    (microsoft.public.access.gettingstarted)