Can't save database objects when changes made

[stanley721]

This has happened to me several times in the past. I make minor changes to a report and when I go to save it or close it out, it asks, "Do you want to save changes?" Of course I say yes and it just sits there, not closing out the report tab. The only way around it that I have found is to re-write the report, from scratch. Much time wasted. Anyone ever see this before?

[RuralGuy]

The next time it happens, if a Compact and Repair does not correct the issue then try *importing* everything into a fresh new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

[stanley721]

I should say that I am using Access 2010 with a .accdb database. I've tried compact and repair numerous times and tried to import to a new database. Same results!

[RuralGuy]

Hmm...I'm out of ideas at this time.

[stanley721]

When I try to create a new database and import, I can import everything OK except when I do the Reports, I keep getting a "The search key was not found in any record" followed by "Name conflicts with existing module, project, or object library," and then "No current record" and then it won't import it. I've even tried just dragging the report object from one database to another and it gives me the previous errors. The original database works fine, considering, but I can't make changes and it seems like it all started since we switched from Office 2007 to 2010.

[stanley721]

I think I have it. on the property sheet for the reports, under other, has an option for "has module". Select NO and that takes care of the problem.

[RuralGuy]

Interesting solution! Thanks for sharing.

[cn1ssr]

I cannot tell you how much time I have spent looking for this solution.

stanley724, I think I owe you a beer!

[aljameelah]

That worked for me too, I just signed up so that I could thank you for saving many hours of frustration.