 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Can not save the file
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? >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. > >Hi, > > [quoted text clipped - 14 lines] > > 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. 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] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.