Ms Access 2010 There Was An Error Executing The Command
an error…” Error message in MS Access Posted on October 22, 2010 by R.Wang Original posted at http://www.articlesbase.com/software-articles/resolving-there-was-an-error-error-message-in-ms-access-971813.html Upgradation or degradation of database between different versions of Microsoft Access is a normal practice followed by the database users. While upgradation and degradation process allow the user to mount the database in a particular version, it might also result in an error message. This error message makes the database unmountable resulting in inaccessibility of data saved in the database. To overcome these situations, you will need to restore the data from an up-to-date backup. However, in case of absence of an up-to-data backup or backup falling short to restore the desired information, you need to use advanced access repair application that can completely repair your corrupted database. Consider a practical case, where you receive the below error message when you convert (degrade) your database from Access 2007 to 2003: “There was an error executing the command" You might also encounter the same error message when you convert your database from Access 2000 to 2003. Once the above error message appears, the data stored in the database becomes inaccessible. Additionally, you encounter the same error message each time you try to mount your database. Cause: The above error message primarily occurs when the database gets corrupted after conversion. Resolution: For complete resolution of the above error message, the first and ideal solution is to use an inbuilt repair utility known as “Compact and Repair." Below are the steps that you will need to follow to use the inbuilt utility: Go to the Tools menu, select Database Utilities and then click Compact and repair Database. Locate and then click the database in the Database to Compact From dialog box, and then click Compact. Select an appropriate folder location for the new file in the Compact Database Into dialog box, type a unique name for the file and then click on Save. In most cases, the inbuilt repair utility repairs your corrupted database. But, if “Compact and Repair" utility is unable to resolve your issue, then you will need to use powerful Access Repair utility. These Access Database Repair tools use high end scanning mechanisms to completely scan and repair the corrupted database. Stellar Phoenix access recovery is a reliable Access Database Repair application. The utility can restore and Repair Access database components like queries, f
Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 03-21-2011, 12:45 PM #1 kessmiller Newly Registered User Join Date: Mar 2011 Posts: 8 Thanks: 2 Thanked 0 Times in 0 Posts What does 'error executing the command' mean? I have a database that I created in Access 2003 that creates a report. The report runs fine when I run it on my computer using Access 2003, but gets and error 'There was an error executing the command.' when I try to run it on another machine running Access 2007. I don't know where to look even http://oraclepoint.com/oralife/2010/10/22/resolving-there-was-an-error-error-message-in-ms-access/ to find out what this error means and can't find any posts on it. Which brings up a general question on the search feature on this site... When I try to search for key words error executing command I get all posts with any of these words. Is there an option to search for only posts with all of these words? I see it in the FAQ section, but not here. kessmiller View Public Profile Find More Posts by http://www.access-programmers.co.uk/forums/showthread.php?t=207013 kessmiller 03-21-2011, 02:54 PM #2 gemma-the-husky Super Moderator Join Date: Sep 2006 Location: UK Posts: 13,140 Thanks: 50 Thanked 885 Times in 857 Posts Re: What does 'error executing the command' mean? i take it you are using the MS switchboard that message is a generic message for any switchboard command that fails maybe the switchboard item isn't set up correctly. maybe the target doesn't exist. maybe the target form/report just didn't open. they all produce a similar cryptic message. i actually modify my switchboard code to provide a more meaningful response. try opening the form/report directly - see if it opens. if it does, then there may be something wrong in the switchboard code. __________________ Dave (Male!) Gemma was my dog if a poster helps you, please click the scales at the top right of this posting, or use the thanks button alongside. gemma-the-husky View Public Profile Find More Posts by gemma-the-husky 03-22-2011, 06:49 AM #3 kessmiller Newly Registered User Join Date: Mar 2011 Posts: 8 Thanks: 2 Thanked 0 Times in 0 Posts Re: What does 'error executing the command' mean? OK. Big duh moment. I had not installed the ODBC links needed on my users PC. They're on mine, so I didn't think of them. Thanks for pointing me in the right direction. How would I edit the switchboard messages to
your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. Error executing the command P: 2 joemoni Hello there, Im getting this error message when 1 user (only him) trying to edit an https://bytes.com/topic/access/answers/654571-error-executing-command access file: "There was an error executing the command". Security wise there is nothing wrong i checked it. Any help please. Thanks in advance May 30 '07 #1 Post Reply Share this Question 4 Replies Expert 5K+ P: 8,127 debasisdas Nothing is clear from your question. Can u please specify your problem in details. May 30 '07 #2 reply P: 2 joemoni Hello again, The problem with M. Access: When i try to open a "form" from the switchboard in this program, i get ms access the following error : "There was an error executing the command" . This program is shared for many users, but i have only one user who's getting this error. I checked the sharing security and all is well done, and it was working normally 1 day ago. I did backup and reapair database also but didnt help. I hope this time i explained better my problem. Thanks again May 31 '07 #3 reply Expert Mod 10K+ P: 14,534 MMcCarthy Hello again, The problem with ms access 2010 M. Access: When i try to open a "form" from the switchboard in this program, i get the following error : "There was an error executing the command" . This program is shared for many users, but i have only one user who's getting this error. I checked the sharing security and all is well done, and it was working normally 1 day ago. I did backup and reapair database also but didnt help. I hope this time i explained better my problem. Thanks again Is this the only command on the switchboard this user is getting an error on, if not the the issue is to do with either security or connections. However, if it is only happening on the one form then we will need to see the code in the Form Open and Form Load Event. Jun 1 '07 #4 reply P: 1 boogaru02 Hello, I have no experience with Access and users at my work are getting the same error as mentioned above: "There was an error executing the command". Can somebody help me find the reason behind this error? A few more details, We use switchboard to access different things on the DB, none of them work. I don't know what other info you all may need, but any help is greatly appreciated. Thanks in advance Jun 28 '07 #5 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Simi