Question Problem with Form in Access 2007

[Mrkeith]

Having a problem with opening my form that i created in access 2007 after making a change. I made a change by adding two more fields on the form and when I close out the form and access, I could not open the form. Can anyone help.

thanks

 

[Trevor G]

Welcome to the Forum,

Have you tried opening the form in design view to see if it opens then possibly remove the extra fields you have added in to see if it corrects it.

If not can you upload a copy of the database, I would zip a copy as you can't have more than 2meg as an attachment.

 

[Mrkeith]

Trevor, the problem is that I can't get into the form design.

 

[boblarson]

Sounds like possible corruption. Can you import everything into a brand new database shell?

 

[Trevor G]

When you open the database by using holding down the Shift Key on the database name and then double click the database name then look to compact and repair it will that do anything

 

[Mrkeith]

Ok. I got it. It works now. Boblarson, it looks like the file got corrupted some how. But i took the steps of save every time i made a change to the form and also the table, query and also report form.

Trevor, thanks for your cooperation.

Thanks again guys you've been a big help.

 

[Trevor G]

Pleased to read you have it resolved.

Nothing worse than a corrupt database...