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?

On Mon, 14 Jan 2008 11:53:03 -0800, Ac <(E-Mail Removed)> wrote:

>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?

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]

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.



"John W. Vinson" wrote:

> On Mon, 14 Jan 2008 11:53:03 -0800, Ac <(E-Mail Removed)> wrote:
>
> >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?
>
> 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]
>

On Tue, 15 Jan 2008 09:29:02 -0800, Ac <(E-Mail Removed)> wrote:

>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.

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]