Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Front End/Back End (2000)

    Easy question for most of you - Is it necessary or a good idea to split a database into a front end/back end even if the database will not reside on a network?

    Thanks.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Front End/Back End (2000)

    Yes, because the database can become corrupted as you are working with it.
    If the corruption is in the front-end, you always have the data in the back-end.
    Also for backup, if you have a copy of the front-end, you only have to backup the back-end.
    Francois

  3. #3
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Front End/Back End (2000)

    Also one of the main reason to split the db is that you can easily make chages to the Frontend db and simply overwrite the user's Frontend to update it without effecting to data stored in the Backend.

    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Location
    USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Front End/Back End (2000)

    Francois and Ricky - Thanks for your responses. It was excactly what I needed.

Posting Permissions

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