Advice sort on a replicating Access 2003 database after an Office 2010 upgrade

Posted on 2011-05-02
Last Modified: 2012-05-11
We inherited a rather complicated Access 2003 database that allows us to share that database with a client through replication.  

The Master is kept on our system, and a replica on the client's computer in another town.  They update and then sync it (the syncronisation takes place in a VB script in the database, with a button on the client's desktop that he presses before and after hes worked on it). The client then lets our staff know it's available to be used.

We're looking at upgrading to Office 2010 in the near future, including upgrading Access to 2001.  I've done some initial testing on the database on a computer that does have 2010 already installed, and it's daily routine tasks seem to work fine.  

My question is, whats the likelihood that we may have issues with the syncronisation step?  Its a bit hard to test the syncronisation without actually upgrading the client to 2010 - which we don't want to do yet.

Question by:bosshognz
    LVL 84

    Accepted Solution

    In general, there have been no major hiccups with moving Access legacy apps to 2010, but I would strongly encourage you to do more thorough testing.

    Assuming that by "replication" you're referring to the builtin methods, please note that Access 2007/2010 do NOT support replication in the native .accdb format. If you leave your database in the .mdb format, you can still make use of the replication services.

    Author Comment

    We do intend to further test if there weren't any glaring reasons for why it wouldn't outright work - you know how a seemingly benign task turns out to be everyone's favourite feature in an application when it gets removed in the next version.
    LVL 84
    Are you using any ActiveX controls in the database? These can be quite troublesome in later versions of Access. Also, Access 2007/2010 seem to be quite a bit pickier in regard to sloppy code (not to say your code is sloppy).

    Author Comment

    Its not my code! Thats why I'm very hesitant about it all.

    As far as I know theres no Active X.  Its all VB and Macros.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    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

    8 Experts available now in Live!

    Get 1:1 Help Now