Re: FE/BE question

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

Allow me to give you some advise.

FrontEnd = Queries, Forms, Reports, Pages, Macro's, and Modules
BackEnd = Tables and Relationships

Steps to Follow:

Step 1. Get Everyone out of the .mdb file.
Step 2. Establish a common drive location for the BackEnd.
Step 3. Establish All Linked and Native Tables (Linked=All in BackEnd ::
Native=Local in FrontEnd).
Step 4. Backup the .mdb file as a Master Original.
Step 5. Split the .mdb file.
Step 6. Convert the FrontEnd to .mde (for Security of your code)
Step 7. Distribute the New .mde file.

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Trying to merge modified copy of database with original.
    ... have them in the same folder on the hard drive), ... if you have six users, you need six copies of the frontend. ... The backend is in a shared folder; the frontend should NOT be shared, ... The mde file has all the design tools disabled so ...
    (microsoft.public.access.queries)
  • Re: Protecting the Design of Form
    ... before deploying the frontend database to the users, ... in a .mde file, forms, reports, and modules are safe from ... tampering - though the tables (linked from the backend), queries, and macros ...
    (microsoft.public.access.security)
  • Re: Newbie ? using multiple users in one database at same time
    ... (in either a mdb file or in SQL/Server) ... a .mde file containing links to the backend along with forms, ...
    (microsoft.public.access.gettingstarted)
  • Re: Newbie ? using multiple users in one database at same time
    ... issues with multiple users connecting at the same time trying to change data. ... mdb file or in SQL/Server) containing the tables, and a .mde file containing ... links to the backend along with forms, reports, code, etc. ...
    (microsoft.public.access.gettingstarted)
  • Re: Design problem : security layers
    ... I'd like to reuse the Objects i write for the frontend in the backend, ... So for the moment what i do is having two packages, ... the credit sub-package will contain all that behaviour that ...
    (comp.lang.java.programmer)