Error converting from 97 to 2000

I am having trouble converting an Access 97 front-end application to Access 2000.  I am getting several "error while loading Form..." and then the last message is "The Visual Basic for Applications project in the database is corrupt".  The 97 version has worked fine for a long time, so I am not sure where to go?  Any suggestions would be appreciated

11/19/2003 2:31:08 PM
access.conversion 3037 articles. 0 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 40

There are many tricks available to try to fix corruptions.
1. Create a new empty A97 mdb and import all the objects from the corrupt
Recompile the code.

2. Decompile the code.

Make a backup.
Test the undocumented /decompile command line switch.

The single command line looks like this (watch the wrapping!):
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"C:\MyDocs\MyFile.mdb" /decompile

This completely removes all compiled code from the project.

Then compact the database and re-compile it.
Then compact again.

See for reasons why this can be very dangerous.

3. Try the undocumented SaveAsText and LaodAsText feature.

If nothing else works:
Peter Miller is the guru for fixing corrupt databases:

"Our most popular rescue service is our Data Recovery Service.
Occasionally, databases can become corrupted.  Usually the inbuilt Repair
capability will correct the problem, or its possible to create a new
database based upon the corrupted one.  If you are unable to recover from a
database corruption problem, and either do not have, or don't think its
feasable to rely upon an older backup of the database, then our service is
just what you need.  Data recovery services are provided for a fee ranging
from US$120 to US$1,200 (although the majority of jobs cost less than
US$600). Our success rate for complete data recovery exceeds 96%. If you
would like us to take a look at a damaged Access database for you, then
please complete the form below. "

Joe Fallon
Access MVP

"Scott" <> wrote in message
> I am having trouble converting an Access 97 front-end application to
Access 2000.  I am getting several "error while loading Form..." and then
the last message is "The Visual Basic for Applications project in the
database is corrupt".  The 97 version has worked fine for a long time, so I
am not sure where to go?  Any suggestions would be appreciated.
> Thanks,
> Scott

11/23/2003 3:12:14 AM
Try importing all of your db objects into a new 
>-----Original Message-----
>I am having trouble converting an Access 97 front-end 
application to Access 2000.  I am getting several "error 
while loading Form..." and then the last message is "The 
Visual Basic for Applications project in the database is 
corrupt".  The 97 version has worked fine for a long time, 
so I am not sure where to go?  Any suggestions would be 
12/29/2003 10:56:59 PM

Similar Artilces:

Linked graphics into a Publisher 2000 document
I have a 400KB document (withgout graphics). I insert two JPEG images each around 200KB into the document. I figure the resulting document should be around 700KB. Result? An 11MB file. I delete the images (document is now 400KB) and instead insert the images using the "Link to File" option. Graphics Manager confirms that the images are linbked into the file. The size should not be more than 500KB. Result? An 11MB file. Question is how can I insert images into a Publisher 2000 documentr without the file blowing up? And why does it blow up? Regards, Richard. Richard wrot...

Front End Exchange 2003 OWA for a Back end 2000
Hey everybody, At the minute we're in the process of upgrading our 30 odd servers to Windows Server 2003. The Domain Controllers are still running Windows 2000. My question is : Can I install an Exchange 2003 OWA on a Windows Server 2003 to connect to an Exchange 2000 Server in a Windows 2000 Domain (Native Mode) Do I have to upgrade the whole domain first ? What about notions of Front End / Back End ? We would like to do this to benefit from the new OWA (As it's sooooo cool :)) Thanks for your replies, Mike You can use an E2K3 FE to connecto to an E2K BE, but you only get OW...

error sending from 5.5 to 2000
When a user sends from an exchange 5.5 mailbox to a user in exchange 2000, they receive the following error: The message was undeliverable because the recipient specified in the recipient postal address was not known at this address The MTS-ID of the original message is: c=US;a= ;p=Express-Scripts;l=TEMMS014-041001192533Z-210060 < #5.1.1> The same user on the 5.5 server can send to other users on the 2000 server. I looked the error up in technet and got 3 kb articles with only 1, kb295377 being anything close to my problem. I checked the entr...

Outlook 2000 doesn't respond after downloading MS update!!
Luckily, my Outlook Express seems to work, but my Outlook 2000 will open, but if I click on a message or do Anything, it FREEZES. HELP!! I rely on calendar functions, other things. HOW could MS allow an update that screws up their own programs? I did restore - to no avail. I lent CD to someone, so can't do "repair." (Trying to get a hold of friend) Please help! I'm in process of job hunt & really need Outlook to function... Thanks, Sherry Did you recently apply SP3 for Office/Outlook 2000 and is Outlook 2000 configured in Internet Mail Only mode? If yes, you...

When launching Outlook I recieve the following error... please he
When launching Outlook 2003 I recieve the following error: The add-in "C:\PROGRAM~1\SPAMBL~1\Bin\461~1.0\SBOLExt.dll" could not be installed or loaded. This problem may be resolved by using Detect and Repair on the Help menu. I ran the Detect and Repair and that didn't work. I ran the repair option from Add and Remove Program in Control Panel and that didn't work. I also un-installed and then re-installed Outlook 2003 and that didn't work. I'm running Windows 2000. Any ideals...? Did you have something possibly called SpamBlocker installed at some point?...

Money 2006 file repair application error
I cannot delete an old account because I get a "file may be courrupt" error so I am trying to repair my 2006 file. Following the deirections, when the progress bar almost completes, I get an application exception and send an error report to MS. My event log has 2 app errors 1) Event Type: Error Event Source: Application Error Event Category: None Event ID: 1001 Date: 4/12/2006 Time: 10:47:26 PM User: N/A Computer: xxx Description: Fault bucket 02266399. For more information, see Help and Support Center at Data: 0000: 42 75 63 6b 65 ...

Fewer normal template problems with Word 2000 or 2002?
I have enjoyed some things about Word 2007, but I keep having problems with macros and templates. I am wondering if (a) macros increase the likelihood of corrupting the normal template in 2007, or (b) if the older versions of Word had as many template problems. I have used Word in 2000, with Office 2003, and now with Office 2007 and I don't ever recall having as many problems as I've had with 2007. What I'm thinking is that if it is simply a macro problem causing corruption, I would simply use 2007 without the macros (they're nice but I can live without them). On the...

Error #2950
Hi, I have three tables from which data I use to create a single table. The data is entered into the three tables via a form. I have a macro set up to create/update the single table through some make table queries and update queries of data within the first three tables. I have this macro tied a close form event and I keep getting a 2950 error when in a multiuser environment however the macro works in a single user envioronment. I only really need to have the single table updated daily. Do you have any good tips on error handling procedures so I can skip running of the qu...

is DCOM error 0x00080012 (Not all the requested interfaces were available) not an error ?
Im checking the return value of a DCOM call by using the macro: FAILED(HRESULT). One particular function call returns the error 0x00080012 (Not all the requested interfaces were available) if the DCOM service is down. Calling FAILED with this HRESULT returns false, meaning that it isnt an error! I think it should be reported as an error as my program cannot call ANY interfaaces beyond this point and crashes. The FAILED macro checks the HR to see if it is negative and 0x00080012 is positive!? Any suggestions? Thanks Andy ...

Exchg2003 First Storage Error
Exchange Enterprise 2003, SP1 on Win2003 - When I attempt to view the mailbox information store within First Storage Group I get an error (Id no. 80040d1b). The only ref. to this error I have found is:;en-us;817309 - checked my registry & server - they match; registry looks fine. I also am getting Veritas Exchg Info Store errors - "database corrupted". I ran the Eseutil defrag - ran successful, but still can't see mailboxes. I found MS tech net info that suggests re-installing Exchange (to repair): http://www.micr...

Error saving a Shared Workbook
I have a user using a shared workbook and gets an error everytime she does this ONE specific change. She deletes a line and then saves and gets a message that says, "EXCEL.exe has generated errors and will be shutdown by Windows... blah blah blah". If she makes anyother type of changes it saves just fine. I also had another user do the SAME change and that person also got that error message. When the file is changed to "Not Shared" then the line is deleted it saves fine also. The problem is obviously with the file itself and that is shared out. can anybody ...

Excel 2000 macro security Level
Hi! I am running an ASP.NET application which ideally opens an Exce spreadsheet with a macro included in it. When I try opening spreadsheet without a macro, everything works fine, but with macros, i hangs on the opening command. I tried to go to Excel 2000 and go t Tools->Macros->Security Level->Low but it still hangs when I try t open the macro spreadsheet. All works fine with the spreadsheet no containing macros, so it really is a question of macro security. But put it to low, so I don't understand how it is still not opening!! An help would be greatly appreciated! Thanks and...

I can no longer convert my files to pdf
I have Publisher 2003 and yesterday, my pdf menu on the top left disappeared and I can no longer convert my Publisher files to pdf. I've even uninstalled/reinstalled the Adobe Acrobat 7 and have also updated to 7.8 but still no luck. The next step was to uninstall and reinstall Publisher and still no luck. Any one know what may be the problem? Thanks. How are you trying to convert your files? When happens when you try? -- JoAnn Paules MVP Microsoft [Publisher] "darrellm" <> wrote in message news:A78B7B52-981D-4FB7-8625-EAD9...

Outlook error message #4
Microsoft Visual C++ Runtime Error. What's the problem? ...

Formatting Cells in Excel 97
Hi Guys, Sorry if I sound real stupid but is there anyway that we can control the column formatting in Excel 97 like let's say column A = GENERAL(6), column B = GENERAL(4), column C = TEXT(18) etc? Appreciate any form of advice, thanks!! I replied in the programming group. Are you seeking a programming answer? It's usually best to only post to one group, and include the remark "Please tell me if I should ask this in another group." On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <> wrote: >Hi Guys, > >Sorry if I sound real stupid b...

Error Code 80070424 12-21-09
I keep getting this Windows update error every time I boot my PC. In the window, it says Windows can't check for updates. Does anyone have any ideas? Recently I installed BitTorrent so could that be my problem? "Norm" <> wrote in message > I keep getting this Windows update error every time I boot my PC. In the > window, it says Windows can't check for updates. Does anyone have any > ideas? > > Recently I installed BitTorrent so could that be my proble...

Is there a way to convert OE 03 form templates?
I have a user that has upgraded from outlook 2003 to outlook 2007 and has a form template from 2003 that is in a FDM extension. Outlook 2007 is unable to read this form. Is there a way to convert this form, or will the user just have to create a new form with their new version of outlook? Any information appreciated. Thanks, -AllenK What happens when you try to install the form? Any error message? -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 Outlook FAQ, HowTo, Downloads, Add-Ins and more

Installation errors. 01-09-04
I'm setting up CRM 1.2 on a completely clean test environment of windows 2000 servers. Near the end of the installation a message pops up "Setup was unable to register the security service." What could be causing this The usual story: To get the MCCRMSecurityService starting, have you tried re-registering it as follows: On your crm server, at command prompt, go to program files - microsoft crm - bin, then run these commands crmsecurityservice -u crmsecurityservice -r -s Peter Lynch "J. Bridger" <> wrote in message news:0aa001c3d6...

Publisher 2000? #2
Is there a place where I can still get version 2000? I've been looking, but all I can find are updates and the 2007 trial. My computer can't run 2007. *If* if can be had, try something like eBay. (I wouldn't buy software that way but that's just my preference.) You may find you have better luck finding a leftover copy of Pub 2003 from some online retailers. (I actually prefer that over 2000.) -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Jason" <> wrote in me...

XP Look and Feel in Windows 2000 using ComCtrl32.dll
Hai I Want to have a XP Look and feel under windows2000 using VC++ and ComCtrl32.dll and does any one have any idea please help me as basically iam looking to develop a Skin Waiting for your reply suresh You will have to draw many of your own components. You could purchase a library like the one from or or or use something like this: These are for Office XP, but you'll get the idea. It's a ton of work: Tom "suresh" <s...

Error in Code
Following is some VBS code I have in my Custom Form developed in Outlook 2003. Line 61 is giving me an error stating: Object doesn't support this property or method: 'Item.GetInspector.ModifiedFormPages' Line No: 61 If you look Line 51 is the same method and it works fine. The funny thing is when I run the code, I get the error, I continue on to the Form, and the code after it works. The code that follows line 61 is dependent on line 61 as evident by if I ' comment it out, I get a separate error asking for objPage2. The code also works if I change the value of one of...

Active X error
I have tried removing the signature, unchecking the Smart Tags, changing the editor to Plain Text as well as to Rich text all to no is the error one of my users gets when she tries to send and email from Outlook - she can receive just fine: "One or more ActiveX controls could not be displayed because either: "1) Your current security settings prohibit running ActiveX controls on this page, or "2) You have blocked a publisher of one of the controls. As a result, the page may not display correctly." ...

Importing into Access 2000
I have a text file 13187 characters long. It will not import or link. Any suggestions? Hi William, Suggestions? First one is to give us a bit more information: What happens when you try? Can you import other text files? What's different about this one? Separated or delimited? How many fields? Where did it originate? On Fri, 7 Nov 2003 14:57:16 -0800, "William Madison" <> wrote: >I have a text file 13187 characters long. It will not >import or link. Any suggestions? -- John Nurick [Microsoft Access MVP] Please respond in th...

Errors found Code 80070490
This appears to be one of those problems that no one seems to have a working solution. Reinstalling an operating system is not a solution it’s a reason to change operating systems. This type of problem was not supposed to happen with Vista. Let’s see some big guns on this one! Update Error: Some Updates not installed: 2 Failed updates (KB967723, KB972145) Errors found Code 80070490 (Unknown Error) Problem signature: Problem Event Name: WindowsUpdateFailure ClientVersion: 7.4.7600.226 Win32HResult: 80070490 UpdateId: AE2C61ED-AC12-4369-BED6-4375CD79CA...

OWA - change password
Getting the "Object Required" error, when somebody is trying to change their password through OWA. (Win2003/Ex FE 2003) Any ideas what could be causing this? TIA! / Per Did you follow the steps in: ? -- Pablo D. Vernocchi Microsoft Exchange MVP MCSA + M / MCSE + Sec "Per Hagstrom" <per.hagstrom@swic.eduNOSPAM> wrote in message news:Ojo%23EozNHHA.1240@TK2...