Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011

    Unanswered: Access Front End Tracking Tables

    Access 2007 FE with SharePoint 2010 BE lists

    The Access 2007 FE is saved to a document library on the Sharepoint site for the users to go and download. Right now I have them doing a read only downloaded and not saving the Access FE to their computer (except temporarily). This is fine for now, but as the FE file gets larger and more use, this method will grow old. My idea is to have the users download the FE file to their desktop or mydocuments folder and just use the application without having to go to the Sharepoint site. The problem that occurs is occasionally I will be updating the FE file and want to let users know (besides via mass email) that they do not have the most up to date FE. I have an idea of what I want to do but I do not have enough Access knowledge to implement the idea.

    I was thinking I could use two tables:
    1 local FE table to store the "version" of the users FE file
    1 Sharepoint list to store the "version" of the most up to date FE file

    This is where I get lost:
    How can I compare the version value for those two tables? Is this possible?

    I want my end result to be:
    When the version values are found to be different, I want to trigger a form to open that says the users does not have the most up to date FE file and provides them the hyperlink to the sharepoint site.

    I am looking for some guidence on what type of query to use (if any) and what trigger event I could use.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    you could do that
    or you could look at the code bank in this forum and see if the method of distributing your front end could work with that code.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts