Microsoft Access 2010 VBA not showing in Access 2003

Posted on 2011-10-26
Last Modified: 2012-06-21
I have a database written in Access 2010, but saved as Access 2003. It works fine in my Access 2010 version, but when I run it on an Access 2003 machine, none of the VBA seems to be there. So, for example, if I have an event associated to a form control, I can view the VBA behind it in Access 2010, but when I look at it in Access 2003, the event is not there.

Is there a reason for this?
Question by:rick_danger
    LVL 119

    Expert Comment

    by:Rey Obrero
    designing/creating a db in a higher version of Access and viewing / using in a lower version always have problems and in most cases does not work at all.

    use a lower version of access if your will using the app in different versions of access
    LVL 19

    Assisted Solution

    I agree with capricorn's post above.

    You may try to check the visual basic references in Access 2003. See the link below, this might be of help to you.

    LVL 77

    Accepted Solution

    You can try using a decompile on your a2003 version, but even if that gets your code back you will have issues with library references which you will have to fix.

    sample decompile command using Run...

    C:\Program Files (x86)\Microsoft Office\Office12\msaccess.exe  "C:\mywork\databases\northwind.mdb" /decompile
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    <No Points wanted>

    From the previous experts posts above, the best thing to do is to only make development changes in the lowest possible "environment" (In your case Access 2003.
    By Access 2003, we mean on a "machine" with access 2003 running.
    Creating the db under access 2010 (even if it is saved as 2003 format) is not exactly the same as simply building the db from scratch with Access 2003

    If you have users with access 2003 only, then you won't be able to use the new feature in 2010 anyway.

    Just make all of your design changes on a "Machine" with acc 2003 installed.



    Author Comment

    Point well made thanks. As you have not asked for points I shall share them amongst the others, but yours is the best for being plain-speaking! I take your point, but can't do that, as the machine is at my customer's office. I will get them to upgrade to Access2010 - they won't like it, but what else can a man do?
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Yeah, I don't want any points because I am simply consolidating what the other Experts have said.

    I understand fully that sometimes you have to use what the customer gives you.
    I was just stating what would be ideal.

    Most developers will have multiple version of access running on their personal machines for situations like this.
    Again, even this is not ideal, because as I stated, you need to be working in the same "Environment" as the users.

    Again, no points please...



    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

    Join & Write a Comment

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    729 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

    23 Experts available now in Live!

    Get 1:1 Help Now