Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 6th, 2006, 08:43 AM
Authorized User
 
Join Date: Jun 2003
Location: Swansea, , United Kingdom.
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Default Corrupt DB - You cancelled the previous operation

Hi,

I have an access database (ver 2000). When I open the database, i get an error message

 "You cancelled the previous operation"

Also, when I try and open and compile a for, I get another error message :

 "The form name Form1 is mispelled or refers to a form that doesn't exist".

The second error is a bit strange as I havent had any forms called "Form1" or any macros etc.

PLEASE HELP!!!




Ta!

Tim

Tim
__________________
Tim
  #2 (permalink)  
Old January 6th, 2006, 11:26 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Take a look at where the debugger stops in your VBA code. That error message usually means that you used a function where an argument for it is misspelled or is calling a table, field, form, report, etc. that doesn't exist.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
  #3 (permalink)  
Old January 6th, 2006, 11:36 AM
Authorized User
 
Join Date: Jun 2003
Location: Swansea, , United Kingdom.
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Greg,

Many thanks for your reply!!!

it seems to stop at the "Option Compare Database" line at the very top of the VB code (happens on any form I open).

Any ideas?????



Tim
  #4 (permalink)  
Old January 6th, 2006, 11:46 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

I don't see how that line causes that problem. Try recompiling the database.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
  #5 (permalink)  
Old January 9th, 2006, 11:59 AM
Authorized User
 
Join Date: Jan 2006
Location: , , .
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Do you get the error if you open the mdb while holding down a shift key? Do you have any missing references? Have you tried creating a new empty db and importing everything into the new db?

HTH RuralGuy (RG for short) acXP WinXP Pro
  #6 (permalink)  
Old January 10th, 2006, 05:18 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

Hi tim did u solve the prob , if not try to sent the error commend that u hsve in the VB module (cupy & paste the comm ) in the mess then we can analys the prob .If ur not have "From1" then in the place of "From1" type the from name that u have (del & type)\*""TRY THIS ONE""*
 Bye
 Pap
  #7 (permalink)  
Old March 26th, 2007, 07:29 PM
Registered User
 
Join Date: Mar 2007
Location: SYDNEY, NSW, Australia.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ive got a similar problem like this, i have an existing Access97 database that works fine, however after converting to Access2003 when i open it, it says "The form name MEDREC is misspelled or refers to a form that doesnt exist. If the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and enter the correct form name".

However when i click OK i dont have access to correct the form name and the dialog box just shuts down and i cannot access the database.

In any case, i know that from opening it in Access97 the form name MEDREC does indeed exist. so i dont know what is going on. I tried holding shift button down while opening and this time i at least got access to the tables, queries, forms whereby the form MEDREC wasnt there.

Any ideas? thanks.

  #8 (permalink)  
Old May 8th, 2008, 07:49 AM
fyz fyz is offline
Registered User
 
Join Date: Mar 2008
Location: , , China.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Sounds like the mdb file is damaged or something. I think you may try Advanced Access Repair at http://www.datanumen.com/aar/. This tool is rather useful in salvaging damaged Access MDB files.

Hope this helps.

Alan


fyz
  #9 (permalink)  
Old June 5th, 2008, 05:12 AM
Registered User
 
Join Date: Apr 2008
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This problem occurs when you use some reserve word or a corrupt form or database. In this situation you should replace the bad form with a copy from a backed up version of the database. If still you get error then use access repair utility. You can use stellar phoenix access recovery utility which repairs forms, tables even modules and macros.
Download link: http://www.repair-access-file.com
Hope it helps



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error 2001 You canceled the previous operation RayL Access VBA 3 December 8th, 2006 03:00 PM
"you canceled the previous operation" error Totenkopf Access VBA 2 June 14th, 2006 02:48 PM
you canceled the previous operation lizhaskin Access 1 July 19th, 2005 12:36 PM
Error 2001: You canceled the previous operation RayL Access VBA 3 May 27th, 2005 07:40 AM
Multiple-step OLE DB operation generated errors. rameshkumarm SQL Server DTS 1 August 28th, 2004 09:28 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.