Concurrent Developers in MS Access 2007

Posted on 2011-04-22
Last Modified: 2012-05-11
Is there a way to allow concurrent multiple developersin MS Access 2007?
Question by:leeroypitre
    LVL 22

    Accepted Solution

    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    I'm not aware of a tool that would allow you develop concurrently and check objects in and out, like Visual Source Safe .  

    However, as long as you were working on completely independent tasks, you could work in tandem with each developer maintaining their objects code and forms, and then import from one to another to create your next baseline.

    Once you create a new baseline, everyone continues to work off of it, saving their changes to their own version, and when ready, you create another baseline.  This would require very careful planning, coordination, and execution.
    LVL 84
    Be careful with VSS and Access. While you can checkout objects and work with them independently, there are some issues with SS and Access. I tried this route with 2003, and ended up in a bigger mess than when I started - corrupt database, versioning issues (i.e changes made by UserA were overwritten by UserB with no notice), etc etc. From my experience, VSS and Access is not a good fit.

    Just my .02, and you may have much better luck than I.

    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)

      No.  As far as VSS, a few that have worked with it have remarked that it didn't work all that well.  Don't remember specific comments, just that it seemed to be more bother then it was worth.

    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    Upon further reading, I notice you have to purchase Visual Source Safe for the solution posted by Nicobo, you might want to consider "SourceAnywhere for Access 2007"

    Author Comment

    We do not have VSS.  Can multipe developers work on an MS Access 2007 concurrently?

    Author Comment

    When multiple people try to modify different objects it does not let us stating the administrator has it locked.
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    Like I said previously.  As long as each developer is working on completely independent tasks, that involve no overlap (not modifying code on the same form, report, query, or code module) and no modifications to the database structure, users can work independently of one another(on their own version of the application), and can merge their projects (import objects into a master) as time goes along.

    But this requires very careful planning, coordination, and execution.
    LVL 84
    To be clear, UserA can work on the SAME Database exclusively. UserB could NOT open the SAME file, even to work on different objects. As fyed has said, you would need to manage multiple copies of Access and merge the changes into a master database.

    If you need concurrent development, I'd encourage you to move to a different platform, like one of the .NET languages, PHP, etc etc. Those fully support multiple developers. Even then, however, you'll have to have some form of source control. There are some free ones out there, of course, so you could perhaps use one of those.
    LVL 26

    Expert Comment

    As everyone has noted this is not supported in Access.
    With incredible discipline, good communication and luck you could build something to facilitate it.
    No two users can open and alter an MS Access database at the same time.
    You would therefore need a folder named 'Master', with a master copy of the file in it.

    Each developer would make a new copy after each build in another folder on each developer's machine, call it folder 'Dev.'
    Each developer would have to communicate to the others what objects he/she intends to alter.
    When your task is complete you would export your altered objects back to 'master' and delete 'dev'
    The next task, you would repeat the process.

    If you don't have luck and communication, two developers will alter the same object.
    Whoever exports last will have their code in the master file.

    With coding and discipline, you could automate the export of altered objects.
    Version numbers could be stored in the tag property of objects that support that.
    Some other method for objects that don't support that could be devised
    Pehaps a table with object names and versions.
    The export code could check to see if the object being exported had been altered by others since the session began.
    It would export and update objects that were unchanged, flag conflicts, and update version numbers

    It will be a constant headache and a whack of planning and coding.

    Another method would be to break the objects in 'Master' exclusively into a number of 'dev' files.
    All the reports in one, queries in another, forms in a third ect
    Or perhaps by object dependencies
    The other objects would be made hidden, perhaps.

    Objects you changed would be pushed to 'master'
    Editable objects would be pulled from it

    Still a headache.
    Still a whack of coding.

    But doable

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now