Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1765
  • Last Modified:

Cannot save Access 2007 Form after making changes in Form?

I have been using an Access Database since I created it in Access 97, then upgraded to Access 2002 (XP) and now in Access 2007.  I have Modifed some of the forms which I originally created in Access 97 and 2002, but now they will not save when modified in Access 2007.  I have read some similar instances on the Internet which people seem to have solved this by "deleting a blank module behind the form".  Is this a possible issue and how wouild I determine if I have a blank form and how wouild I delete it using Access's GUI since I do not know VB?
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The best method to use is to build a new, blank database in 2007 (use the .mdb format), then import all your objects to that new database. There have been many issues reported when "upgrading" to 2007, and this methods seems to solve the bulk of them.

I haven't heard of any issues with a blank module error. Forms do not, by default, have an associated Code Module, and only are provided one if you enter VBA code. YOu can review the modules present in your project from the VBA editor window ... and you can remove a form's Code Module by setting the HasModule property to No (this is done in the Properties window).
cmsamfordAuthor Commented:
Setting the HasModule to no worked.  That was it!!!
Thank you.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now