Can not save the file

A

Ac

Hi,

I try to save the modified file; after I click the save button on the
toolbar, the Microsoft Office Access message box appear and the message is:
The Save operation failed. What is wrong? What should I change to save my
file?
 
J

John W. Vinson

Hi,

I try to save the modified file; after I click the save button on the
toolbar, the Microsoft Office Access message box appear and the message is:
The Save operation failed. What is wrong? What should I change to save my
file?
Click to expand...

What are you trying to "save"?

An Access database file is not very much like a Word or Excel document. It's a
container for multiple tables, forms, reports and other objects. Any time you
make a change to one of the objects in the database, it's saved for you, right
then and there. It is not necessary (or even possible) to "save the database".
Similarly, there is no "Save As" option - to make a copy of the database you
must close Access and copy the .mdb or .accdb or whatever file using Windows
Explorer.

John W. Vinson [MVP]
 
A

Ac

Hi John,

After I modified the VBA code of a form, I tried to save it. When I clicked
the save button, the error message shaw up.
 
J

John W. Vinson

Hi John,

After I modified the VBA code of a form, I tried to save it. When I clicked
the save button, the error message shaw up.
Click to expand...

It always helps to be specific in your original post: that was certainly not
obvious!

Did anyone else have the database open at the time? You must have *exclusive*
access to the entire database in order to change VBA code. For a multiuser
system you should really be using a split database, with the tables in a
shared "backend" and everything else in a "frontend"; each user would get
their own copy. As you make design changes to the frontend you can create a
..mde file (preferably) which would be distributed to the users.

If you had the database open exclusively, please post more details about just
what you were doing and the error message. Does the VBA project compile
without error (Debug... Compile on the menu)?

John W. Vinson [MVP]
 
Top