Saving in Access

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

I just currently had to convert to Office 2007. I had an access program in
Office 2000 that we had to convert to Office 2003 then to Office 2007, but
now the access program is not saving my additions to the 2007 edition of the
program. Do you know why it will not let me save or what I could be doing
wrong?
 
Nicole

Are you receiving an error message? If so, what does it say?

Are you using Access 2007? Is the file an .mdb file, an .accdb file, or an
"executable" (.mde or .accde)?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Are you saying the data is not being saved as you add or modify records
Or
Are you saying that changes to the database structure (fields, tables,
queries, forms, and reports) are not being saved?

If the latter, you might check with your IT department and make sure that they
are not loading a fresh copy (on start up) of the front-end database from a
master copy that is being stored on a server.

I have that situation at a couple of sites that I support.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
As I modify and add my records it is being lost. It stays put for the day
then the next day they are all gone. Our IT department on campus had no idea
what was going on. They told me to try using this site to figure it out.
 
Nicole said:
As I modify and add my records it is being lost.
It stays put for the day then the next day they are
all gone. Our IT department on campus had no
idea what was going on. They told me to try
using this site to figure it out.
Click to expand...

One thing that causes this kind of symptom is that IT does backups, someone
else needs a backup restored, and your database was backed up in the same
"lump" as theirs, so your changes end up being over-written by your own
backup, which you didn't ask to be restored. That's not to say that is your
problem, but it has been known to happen.

Almost certainly, it is not an Access problem.

Larry Linson
Microsoft Office Access MVP
 
Do you know what I can do to fix this? <this being the IT department restoring backups and overwriting the database>
Click to expand...

Make them stop.

Access cannot POSSIBLY prevent IT from destroying your database, any more than
Word could prevent them from destroying your documents.
 
Does it matter that my computer is in xp and not vista?
Click to expand...

It's perfectly possible to screw up either one... and it's prefectly possible
to use either one effectively.

In short, no.
 
Back
Top