Unwanted form will not delete

[jade1001]

Fellow Geeks,

I am trying to convert a database from Access 97 to Access XP. In doing so I get an error. It reads:

Microsoft Visual Basic

An error occured while loading 'Form_Enter Graduation Data'. Do you want to continue loading the project?

Yes | No | Help

--> Click Yes

Microsoft Acess

The Visual Basic for Applications project in the database is currupt.
OK

--> Click Ok

Nothing is converted.

I try to just open it and get the same two error messages.

Our database happens to be split in half. The front half has forms, queries, and such. The rear half has the actual data. The rear half converts fine. No problems. The front half which has this currupt form won't convert because of this form.

The user says what had happened when she created it her computer crashed and the rebooted on its own. The form was never properly saved or exited. When she tried to go back in to delete it to start over she gets this error message:

Microsoft Acess

The Save operaton failed.

OK

-->Press Ok

Microsoft Access

Invalid data format

OK | Help

--> Press Ok

I tried deleting it and get the same error message. However, you can open this thing fine and design it. But the form is not needed.

This obnoxious form has been here since the Year 2000. -- Two years. It is preventing us from updating the database to Access XP. If anyone knows how to kill this one particular form or has any suggestions as to how to uncurrupt it please, please let me know. I don't know much about Access or use it at all. Any help or suggestions would be greatly appreciated.

Thanks,
jade>:O>

 

[THoey]

Did you try to create a new database and then import the "wanted" objects into it? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[jade1001]

This database (the front half) is nearly a half gig in size. Its our colleges database. It holds student records. Its just one form that is holding us back that we can't seem to delete. Its a god awful thing. I don't know what else to do. I've tried creating another form and theb saving right on top of it. You know, give it the same file name and all but I get the save operation failed error message followed by the invalid data format.

I have thought about creating another database and importing everything but that form in it. But it would take months. There are thousands of queries and such. I also have to support the colleges 800+ users. I may try creating a new database as a last resort.

Thanks for your response and input, it is greatly appreciated,

jade>:O>

 

[BanditWk]

Did you repair/compact the front-end yet? This normally fixes any corruption.

However, there are a few ways to delete objects in Access.

1) DAO Code:
DoCmd.DeleteObject acForm, "NameOfForm"

2) Macro:
DeleteObject
Form
NameOfForm

These are just off the top of my head.

HTH
Roy
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

 

[jade1001]

Hi Roy,

We've already tried the repair/compact method. Haven't tried deleting objects in access using method 1 or 2. My problem is, I don't know much about access. I'll give it a shot and see what happens.

Thanks for your input, it is greatly appreciated.

jade>:O>

 

[BanditWk]

Hey Jade!

If you need help, contact me directly - it seems that my work schedule today is going to be so minimal - and to think that I forgot my pillow at home!!


Roy McCafferty
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"I do this because I know I can and I'm bored at work - no need to send flowers, wine, dinner, or coffee... Just send me a smile to show me that I've helped." ~ Roy McCafferty, seen on a corner in Las Vegas with a sign that said, 'Will work

 

[SQLWilts]

Another thought - dunno how much help this will be:-
Firstly, make sure that you set the ionitial form to None. Try doing a start/run and type "msaccess.exe /decompile" (without the quotes) or give the full path to Access. When access opens, navigate to your Database. You should get a message about converting your modules to the current version of VB. Now try deleting the form. If it works (and even if it doesn't) open a module in design mode and choose "compile and save all modules" from the debug command.
Fingers crossed this may help.

Tony