Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Posts
    13

    How to best deploy a database?

    Hi,



    Itīs my first post, so be gentle!

    Access 2007 on XP in a Windows server network.

    I am designing a database for two types of users. Those who edit and those who search. I donīt want any of them to be able to look directly into the database. I just want to let them pick either an input form or a search form.

    What is the best method? Is there anyway that I can deploy the database without making them start the whole access program? or is my only hope to play with the options settings so that only a start-up form is shown with two buttons. - one to start each form?

    thanks for any design tips,

    Robert

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    I would urge you to set up permissions so they only see the buttons on the menu/switchboard that affects them. See this tutorial for one example.

    http://www.mrexcel.com/forum/showthread.php?t=248191

    Next I would make sure to hide your Ribbon so that they can only open close and print. Set your initial form to open when the db opens and then finally split your db between front and back ends.

    Here is a link on splitting your db.

    http://www.hitechcoach.com/index.php...split-database

    Alan

  3. #3
    Join Date
    May 2012
    Posts
    13
    Thanks for your reply.

    Just a quick comment about splitting my back-end and front-end. What happens when more than one person edits and saves at the same time in the same table? As far as I understand, a front end is only the machanism to enter data (ie the form) but the database is then used by all users....Is this safe?

    cheers,

    Rob

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    All the experts say this is the way to go. If you want more opinions on it. Do a google search but everything I read says to do this way.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 05-16-2012, 12:48 AM
  2. Replies: 2
    Last Post: 04-16-2012, 10:24 AM
  3. Replies: 17
    Last Post: 01-15-2012, 11:37 PM
  4. Replies: 20
    Last Post: 08-08-2011, 01:34 PM
  5. Replies: 3
    Last Post: 05-15-2011, 10:52 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums