Results 1 to 5 of 5
  1. #1
    fishbase is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Location
    Annapolis, MD
    Posts
    4

    Application Versioning

    I keep production and development copies of my front end and do exports of changed objects when I am ready to deploy. Right now the File->Database Properties->Summary->title says "Blue Crab Data Entry v1.9" and if I remember I had increment it in both versions when I do a release. I hate that system.

    I would like to hear about best practices for this sort of thing.

    -Greg

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    there is no best practices; there is only company policies. Most use an integer for a major release and the alpha or decimal for a minor release

  3. #3
    fishbase is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Location
    Annapolis, MD
    Posts
    4
    I was more leaning towards solving the technical problem of keeping the version numbers in sync in both dev and prod environments without hand-updating.

  4. #4
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Create a SystemParameters Table with a "Version" field. Then just reference that field. This table can also be used for handling incrementing values where you don't want missed numbers and similar (which can happen with the standard AutoNumber field type).

  5. #5
    fishbase is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Location
    Annapolis, MD
    Posts
    4
    That would do it, and I do use tables like that (I call them "config"), but having info about the application in the data doesn't feel quite right (nitpicky bastard). I think I'm going to make a query called Version:

    select "V1.9" as Version;

    That I can export to production along with the latest changes.

    Thanks for all your help!

    -Greg

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

Similar Threads

  1. Tax Return Application
    By Hobbledehoy in forum Access
    Replies: 1
    Last Post: 04-18-2010, 05:41 AM
  2. Accessing Another Application
    By searle in forum Programming
    Replies: 2
    Last Post: 03-24-2010, 08:17 PM
  3. Access 2002 ADP application in VSS
    By Accessdev in forum Access
    Replies: 0
    Last Post: 12-16-2009, 12:52 PM
  4. Replies: 0
    Last Post: 08-26-2008, 09:22 AM
  5. Access application to Web based application
    By admaldo in forum Access
    Replies: 0
    Last Post: 06-12-2008, 06:22 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