Access database not saving changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Byrne - 04 Sep 2006 10:38 GMT

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

Reply to this Message

Chris Mills - 04 Sep 2006 10:57 GMT

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

> 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.
[quoted text clipped - 8 lines]
>
> Cheers

Reply to this Message

Rick Brandt - 04 Sep 2006 12:06 GMT

>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.
[quoted text clipped - 6 lines]
>
> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

CurtainMary - 07 Sep 2006 08:04 GMT

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

> >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.
[quoted text clipped - 28 lines]
> *design changes* to your forms and/or reports. It does not ask that question
> about *data* changes.

Reply to this Message

Jerry Whittle - 08 Sep 2006 17:09 GMT

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.

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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.
[quoted text clipped - 8 lines]
>
> Cheers

Reply to this Message

Alan Byrne - 11 Sep 2006 09:09 GMT

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

> 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
[quoted text clipped - 22 lines]
> >
> > Cheers

Reply to this Message