Database Deployment - conversion from Access 2003 to 2010

Posted on 2014-08-13
Last Modified: 2014-08-13
OK.  I am planning on upgrading network databases from Access 2003 to Access 2010. I will start with the FEs, and as I upgrade machines from Access 2003 to 2010, I will switch them over to the new aacdb front ends.
I will still leave all the back ends as Access 2003 until I get 03 Off of all computers (except mine of course, for future BE upgrade).

In the past, when I was involved in a conversion from Access 97 to Access 2003, I was really worried about messing up the old JET database an having databases upgraded by users. I had a registry fix to have Access 2003 NOT ask the upgrade question.

So far, the testing from 2003 to 2010 is going much easier.  I am converting copies of the FEs and having them work with copies of the BEs - as I work out any problems.  

Are there any real gotchas here?  If I have access 2003 and 2010 both installed and I am bouncing back and forth between production and test . . . . do I run the risk of touching a 2003BE with Access 2010 and somehow "poisoning it" so I cant open it in 2003 ant longer? If I follow my proposed method of deploying 2010 aacdb FEs side by side with the old 2003 FEs and leaving all the 2003BEs alone until after the FE upgrade and Office upgrade on computers, will I BE OK? Can aacdb FE and a 2003 FE access the same 2003 MDB BE(s) without any problem???
Question by:MrSlithy
    LVL 1

    Author Comment

    In the past, I had local FEs copied down to each desktop. I am thinking about just sticking with network FEs also
    LVL 75

    Accepted Solution

    "In the past, I had local FEs copied down to each desktop."
    MUST do.

    "I am thinking about just sticking with network FEs also"
    Must NOT do.

    Each user should have a copy of the FE on their local workstation, linked to the common BE. This is the tried and tested approach used by most all Access pro developers.

    There should be no issue of an A2003 BE linked to an A2010 FE ...

    "If I have access 2003 and 2010 both installed "
    I suggest not ... modifying an A2003 MDB in the A2010 environment, an then opening the MDB back in the A2003 environment ... if that is what you are asking.  Many people have had corruption issues in doing so.

    On the flip side, there s/b minimal or no issues working with an MDB in the A2010 environment.

    LVL 1

    Author Comment

    Thanks MX,

    As soon as I wrote that about network based FEs, I knew I was wrong. I was just hoping all the corruption issues I recall during my research in 97 to 2003 might be no more. I will heed your advice.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    728 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

    15 Experts available now in Live!

    Get 1:1 Help Now