View Full Version : How do I save an Access file?
vanbarkley
Jul 14, 2011, 02:25 PM
When starting a new file in access how do you save? I'm new to using Access.
ScottGem
Jul 14, 2011, 05:52 PM
When you first create an Access database you give it a name and choose a location and the file is created. As you add objects or change the design of existing objects you save the object itself. Objects are forms, reports, queries etc. When you enter data into tables or through forms, as soon as you move off the record, the data is saved.
vanbarkley
Jul 15, 2011, 12:35 AM
well its still clear as mud... when saving as... save object as or save database as... not even sure what that is. Ive tried to save object as - it turns into a table ( I see it show up on the left side under all access objects.. then broken down again into tables,queries,forms,reports,etc) then asked file value?? Eekkkk what?? Help!
ScottGem
Jul 15, 2011, 03:30 AM
Access doesn't work like Word or Excel or many other programs. You don't generally use Save As at all.
You don't say what version of Access you are using. But generally there is a Save icon (a floppy Disk icon) either on the Quick Access bar in the upper left (2007 and later) or on one of the toolbars (earlier versions) and you just need to press that to save the object. But you ONLY need to save in Design mode. You only need to save when you make Design changes to an object. Generally, if you make design changes and close the object, Access will prompt you if you want to save.
You do not have to save data changes. You do not have to save the whole Access file. You do not have to save an object when you open it for use. For example, you open Report in Print Preview, then print it and close it. This does not require a Save action since no changes were made. Or you open a Form, add some new records, then close the form, again, no Save action is required.
Access is a unique program in many ways, so you have to change your mindset to some extent.
P.S. when posting a follow-up question or info, please use the Answer options at the bottom of the page rather than the Comments.