2007 not saving changes?!

Q

QB

At first I thought maybe it was my imagination, but now I am able to
replicate this fault a multitude of times.

I can work on a form, change a cbo's RowSource (SQL) and say yes to save
change when closing the QBE. Close the form (which doesn't propmt to save
changes?) and when I reopen the form my changes are gone!?

I work in the VBE modifying a function I am working on, force the save (icon
or file->save) close the form and reopen and my changes are gone?!

What is going on? This NEVER happened in 2003!

I love working with Access, but doing the work once is more than enough for
me. Is this a known issue? Is there a fix?

I already did a compact and repair, no change in behavior.

QB
 
A

Allen Browne

Suggestions:

1. Make sure you have applied Service Pack 2 for Office 2007. There was a
bug like this that was fixed in SP1 or SP2. You can download SP2 from:
http://www.microsoft.com/downloads/...18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en

2. After you change the RowSource property, do both of these:
a) Move to a different property in the Properties box, and
b) Explicitly save changes before closing the form.

3. If you are still stuck at this point, follow the steps in this recovery
sequence in order:
http://allenbrowne.com/recover.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close button without Saving changes 4
Closing form without saving changes 4
Change form property at runtime 5
Access 2007 Issue 4
"Do you want to save changes" not working... 1
Access 2007 not saving changes to a form 1
Can't save data label/leader line formatting in Excell 2007 3
Close form without saving changes 3

Top