Results 1 to 3 of 3
  1. #1
    Tammy is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2014
    Posts
    29

    Splitting a Database and use Runtime for accessibility


    Hi All
    I'm new to this forum but have certainly been reading the threads and gleaning a lot of information from the users. Thank you all.

    I'm in the middle of developing a database for our engineering group to track projects. I've got a question:

    I'm using Runtime because none of our group has MS Access loaded on their system. So, I'm providing a link to the participant to download the free Runtime Software and providing a Shortcut to the database in the shared area.

    My question is, when I split the database and provide the users with the front end do they still require runtime? Do I still provide them the link to download the free Runtime software and if so, do I save both the back and front end with the .accdr extension? I'm assuming that since they will have the front end on their systems individually they will no longer require the Shortcut.

    The way the system is currently, it seems that only one user is permitted in the database at a time as it is locked out. I would like for more than one user to be able to access the database at a time. I've set the Default Open Mode to Shared so I'm not sure why it gets locked down when a user is accessing it.

    Any guidance would be appreciated.

  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,772
    As I understand runtime, users still need the Runtime app and only the frontend is accdr.

    Each user should have their own copy of the front end to run, not a shared file. Review https://www.accessforums.net/code-re...31/index2.html
    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
    Tammy is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2014
    Posts
    29
    Perfect! I'm going to try it today and see how it works.

    Thanks

    Tammy

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

Similar Threads

  1. Splitting Database
    By Shadab Kamal in forum Database Design
    Replies: 2
    Last Post: 11-17-2014, 03:51 PM
  2. Splitting a database
    By Pure Salt in forum Access
    Replies: 4
    Last Post: 07-08-2014, 09:47 AM
  3. Splitting my database.
    By bcox9 in forum Access
    Replies: 7
    Last Post: 12-17-2011, 06:23 PM
  4. Splitting Database
    By injanib in forum Database Design
    Replies: 0
    Last Post: 02-25-2011, 11:08 AM
  5. splitting database
    By colotazzman in forum Database Design
    Replies: 2
    Last Post: 02-10-2011, 09:12 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