|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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
|
|
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
"Alan Byrne" <AlanByrne[ at ]discussions.microsoft.com> wrote in message
news:058F6EB1-6911-4891-B9BE-B93600A5A3F0[ at ]microsoft.com...
[Quoted Text] > 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
|
|
"Alan Byrne" <AlanByrne[ at ]discussions.microsoft.com> wrote in message
news:058F6EB1-6911-4891-B9BE-B93600A5A3F0[ at ]microsoft.com...
[Quoted Text] >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.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
|
|
It looks like you have a property set Required = Yes but you left it blank.
Allen Browne has an explanation on his website'
CurtainMary
"Rick Brandt" wrote:
[Quoted Text] > "Alan Byrne" <AlanByrne[ at ]discussions.microsoft.com> wrote in message
> news:058F6EB1-6911-4891-B9BE-B93600A5A3F0[ at ]microsoft.com...
> >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.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>
>
>
>
>
>
|
|
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.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Alan Byrne" wrote:
[Quoted Text] > 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
|
|
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
"Jerry Whittle" wrote:
[Quoted Text] > 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.
>
> --
> Jerry Whittle
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Alan Byrne" wrote:
>
> > 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
|
|
|