Results 1 to 6 of 6
  1. #1
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419

    Access program or DB as a server program with admin control

    To the very specialist that knows of this,

    Can we create an access database or program that is on a sever and allowers users to go to the link and download it (the database or program). Once is downloaded, the user can’t copy, delete or recopy or go into the code or alter it but could only use it as an application or database.



    The adminstrator however can control it via server where Access is somehow connect to it.

    If not all can be done but at least some would be nice. Please advise ?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Once is downloaded, the user can’t copy, delete or recopy or go into the code or alter it but could only use it as an application or database.
    a wide ranging question which is not very clear as to the expectation.

    Access is a file based client application - so users can copy it or delete it
    you can prevent users from going into the code by providing a .accde
    The adminstrator however can control it via server where Access is somehow connect to it.
    what does this mean?

    Are you aware about splitting the db?

    The requirement is the db is split into front end and back end . The back end is tables only and might be sql server/oracle/another rdbms other than access and is located on your server. The front end is everything else and what the user has and is located on their local drive as a file so can be copied/deleted through normal windows permissions. The backend can be protected by appropriate server user rights, but to use its users need read/write permissions as a minimum.

  3. #3
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    How do you provide .accde ? And how do you split the dB ?

  4. #4
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    How do you provide .accde ?
    ensure your code compiles without error (ensuring you have 'option explicit' at the top of every module) then go to File>Save and Publish and select 'make accde'

  6. #6
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    Moke123 Thank you for the info. I believe it’s an interesting read.

    Ajax, sounds good. Good to know.

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

Similar Threads

  1. Using 32-Bit Database in 64-Bit Access Program
    By Robert2150 in forum Access
    Replies: 2
    Last Post: 02-15-2017, 07:46 PM
  2. Replies: 1
    Last Post: 11-28-2015, 07:54 AM
  3. Replies: 1
    Last Post: 11-15-2014, 12:41 PM
  4. C program: read/write Access database
    By serendipity1276 in forum Programming
    Replies: 1
    Last Post: 08-15-2011, 01:15 PM
  5. Program a 30-day trial into my Access Program?
    By genghiscomm in forum Programming
    Replies: 1
    Last Post: 05-26-2011, 02:14 PM

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