Question re Access 2003

[Guest]

I recently installed Access 2003 (part of office pro 2003) on a laptop.
Files created in Access 97 were then copied, converted andsaved. When I work
on the files, make an error and try to exit, Access saves the data without
giving me the option to exit without saving - can anyone help?

Thanks

Dave

 

[Douglas J. Steele]

What exactly are you doing when you make an error and try to exit?

 

[Dirk Goldgar]

I recently installed Access 2003 (part of office pro 2003) on a
laptop. Files created in Access 97 were then copied, converted
andsaved. When I work on the files, make an error and try to exit,
Access saves the data without giving me the option to exit without
saving - can anyone help?

Hi, Dave. I'm not sure whether you're describing normal Access behavior
or not. Are you talking about *data* being saved, or changes to the
design of forms, reports, tables, etc.? I would expect data to be saved
without any warning prompt, because this is the normal behavior of
Access. I wouldn't expect design changes to be saved without a warning
prompt, unless that warning were switched off. For example, if you have
executed the statement

DoCmd.SetWarnings False

(intending to turn the warnings back on again before exiting), and then
have some sort of error that prevents the

DoCmd.SetWarnings True

statement from being executed, design changes will be saved without
warning for the duration of that Access session.

 

[Guest]

I recently installed Access 2003 (part of office pro 2003) on a laptop.
Files created in Access 97 were then copied, converted andsaved. When I work
on the files, make an error and try to exit, Access saves the data without
giving me the option to exit without saving - can anyone help?

Thanks

Dave

Dirk,

Thanks - yes when I make errors in entering date (it's a medical database
with sometimes long, complicated entries) and then go to exit, assuming it
won't save the errors, it does save them. Most, if not all MS Office Family
programs will pop up a warning if you try to exit without saving.

 

[Dirk Goldgar]

Thanks - yes when I make errors in entering date (it's a medical
database with sometimes long, complicated entries) and then go to
exit, assuming it won't save the errors, it does save them. Most, if
not all MS Office Family programs will pop up a warning if you try to
exit without saving.

That's not the way Access works, or has ever worked. Because Access is
a database program, it assumes that the data you enter for each record
is what you meant to enter, unless you explicitly tell it to undo your
changes. Remember that you are normally entering one record at a time.
Each record in Access is automatically saved as you leave it, whether
you do that by moving on to a new record or by closing the form. Data
entry clerks would scream if they had to confirm each record after
typing it in.

It is possible to program an Access to override this default behavior,
but it's not just a matter of changing an option setting, and it's not
usually a good idea. If you really feel you have a situation that
warrants it, you can find many discussions of various techniques to do
it by searching Google Groups.

Dirk in NJ <g>