Results 1 to 2 of 2
  1. #1
    rodeoboy is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2011
    Posts
    20

    Splitting a Database Question about reports

    From what I have been reading on this forum and in a book I bought, when the database is split the Frontend keeps the reports and backend keeps the tables.

    Now I am to copy the frontend to all users. What happens when someone makes a new report?

    How does that new report get distributed?

    How is that managed?



    Rodeoboy

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    "Someone", or you? Most of us don't let users create anything, so we would be the only ones making a new report. There are utilities available like this:

    http://autofeupdater.com/

    or you can write a batch file:

    http://thatlldoit.com/howtosarticles.aspx#fe_updater

    I wrote a little VB6 app that checks a version table in the front end. If the version on the server is greater than the version on the PC, it copies down the new version. Either way it then starts the local copy.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. splitting database
    By colotazzman in forum Database Design
    Replies: 2
    Last Post: 02-10-2011, 09:12 PM
  2. Splitting DB; Keeping the Forms, Queries, Reports in BE
    By evander in forum Database Design
    Replies: 2
    Last Post: 07-07-2010, 04:59 PM
  3. Splitting a Database related questions
    By Matthieu in forum Access
    Replies: 5
    Last Post: 04-01-2010, 10:42 AM
  4. Database Splitting
    By Matthieu in forum Access
    Replies: 8
    Last Post: 02-08-2010, 03:37 PM
  5. Splitting a Database related questions
    By Matthieu in forum Forms
    Replies: 3
    Last Post: 11-17-2009, 10:49 AM

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