Access database not saving changes

[Alan Byrne]

I have an access database that doesn't save any changes. When I open it,
make changes, click save, exit and go back into it the changes are not there.

When I open the acces database, make changes and exit without saving, the
"Do you want to save changes" prompt doesn't even occur.

User has full access to the access file, it isn't configured as read-only
and I've tried doing a detect and repair without joy.

Does anyone have any other idea's?

Cheers

 

[Chris Mills]

Do a cold reboot. ("cold" means switch the power off)

Repair/Compact your database. Have you done that?

What version of Access? What SP level? What Windows?

It's not a known problem I know of. It's a problem with your PC, I would say.

Therefore, can you try on another PC? (since we wouldn't know if it's your mdb
or your PC or anything else really)

Chris

 

[Rick Brandt]

I have an access database that doesn't save any changes. When I open it,
make changes, click save, exit and go back into it the changes are not there.

When I open the acces database, make changes and exit without saving, the
"Do you want to save changes" prompt doesn't even occur.

User has full access to the access file, it isn't configured as read-only
and I've tried doing a detect and repair without joy.

Does anyone have any other idea's?

If you make entries in a bound form one of three things should almost certainly
happen...

1) You get a message on the first keystroke that changes are not allowed.

2) The changes are accepted and saved.

3) The changes are accepted, but you get an error when the save is attempted.

A form that accepts input without protest, but which does not save them would in
most cases indicate that the form is not bound to a table. Are you sure yours
is?

How are you determining that entries are not saved? Are you examining the table
directly or just opening the form? A form with its DataEntry property enabled
will always open "blank" and will not show previously saved records. Perhaps
this is what you are seeing.

Normally Access only asks "do you want to save changes?" when you have made
*design changes* to your forms and/or reports. It does not ask that question
about *data* changes.

 

[CurtainMary]

It looks like you have a property set Required = Yes but you left it blank.
Allen Browne has an explanation on his website'
CurtainMary

 

[Jerry Whittle]

I'm assuming that you mean changes to forms, reports, ect., and not just data
changes. Actually compact and repair might be part of the problem or at least
an indication of the problem. Go to Tools, Options, General Tab and turn off
Compact on Close if enabled. See if your changes stick then.

If they do, I have some bad news. You probably need to wipe your hard drive
and reinstall everything! I had a problem where compact and repair, either
manually or during shut-down) threw away my hard work on forms and reports.
Thought that particular mdb file was corrupt but the problem happened on
numerous databases including new mdb's. Tried a system restore on XP but
didn't help. Uninstalled Access 2003 and reinstalled it. No joy. Uninstalled
Office Professional and renstalled. More of the same. Finally wiped the hard
drive and reinstalled everything. That fixed the problem.

 

[Alan Byrne]

Fixed my problem by exporting the data into a new database. Used up enough
time troubleshooting etc.

The db didn't have any forms etc, I also done detect and repair and it
wasn't a problem for only one machine, the issue occured on multiuple PCs.

All ok now though.

Cheers