Macro Error

Posted on 2011-05-03
Last Modified: 2013-11-05
I have an Access 2010 database.  When I try to run it from my machine it works great but when I try to run it from another machine I get this error (see attached screenshot).  We are both using a desktop shortcut to the exact same application sitting on our server.  How do i fix this?  macro error
Question by:gcgcit
    LVL 26

    Expert Comment

    Are you both using the same version of Access?
    Are you both usng the same version of Windows?
    Are you both using 32 bit or 64 bit Windows?
    LVL 31

    Expert Comment

    Could be a linking issue.  I get the same on one of my databases, if it is moved to another computer where the back end needs to be relinked.  If this is a split database, try canceling out of the macro error and relinking.  To prevent the error in future, after moving the database, open it by Shift-clicking in the Explorer pane, to avoid running the macro, and do the relinking.
    LVL 12

    Expert Comment

    Is your Access database split in FrontEnd or BackEnd?
    If so, what about the user Access to the BackEnd on network?

    LVL 74

    Accepted Solution

    What version of Access Please?

    Is this DB using Access' built in User level security?
    If so, then make sure the user has the correct security permissions.

    <but when I try to run it from another machine...>
    Do you log into the same account (profile) on both machines?

    Make sure that all users have the proper (same) permissions on the network.

    Finally, consider moving away from macros (if possible) and using VBA, where error handling is a bit more robust,or.r_gc.r_pw.&fp=822bf32b5c0e0691

    LVL 31

    Expert Comment

    If you are using an AutoExec macro, you might be able to move to VBA code run from the Load event of a main menu.  As boag said, VBA is a lot better at handling errors.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    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…

    759 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