Results 1 to 4 of 4
  1. #1
    Daniel2000 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    34

    data input via browser

    have developed an access database whereby multi users are using via front end application. I have split the databse into back end and front end.

    problem is each time i make a change to the front end, I have to go to each pc to update. Apart from this, any other programmer can easily see all my workings and can copy my database.

    I want an option whereby when i make any changes to the front end, then the user will get the change upon the next login. I was thinking of using the front end over the local intranet web browser. will have one front end and all users will be connected to that. any changes i make will be on that front end and they will see the change upon next login.



    My other problem is that I do not want the front end to be stored at the user's end as any programmer can access my tables, forms, queries, reports, macros even if i disabled the navigations option.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Here is how I manage multi-user database http://forums.aspfree.com/microsoft-...ue-323364.html

    And about customizing the ribbon http://forums.aspfree.com/microsoft-...at-303789.html
    Last edited by June7; 05-29-2014 at 11:41 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    What about making an MDE database? They cant access anything but the program. (but it must compile)

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by ranman256 View Post
    What about making an MDE database? They cant access anything but the program. (but it must compile)
    MDE's are good for removing the VBA but still need to remove access to Options via the backstage and or the Shift key in order to restrict viewing and editing data within tables.

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

Similar Threads

  1. Need Help Update/Input Data
    By BigBig5 in forum Access
    Replies: 3
    Last Post: 05-21-2014, 09:30 AM
  2. Data Type to input data number
    By TioAdjie in forum Access
    Replies: 5
    Last Post: 02-17-2014, 11:21 AM
  3. Replies: 3
    Last Post: 08-07-2013, 06:03 AM
  4. Sub form data input
    By ghard123 in forum Forms
    Replies: 2
    Last Post: 04-15-2012, 04:47 PM
  5. Using Reports to input data?
    By yes sir in forum Access
    Replies: 2
    Last Post: 09-03-2010, 10:50 AM

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