Home All Groups Group Topic Archive Search About

Access 2002 Full Data User cannot save. Save grayed out.

Author
26 Oct 2007 8:45 PM
Briklyn
Just changed to permissions in a database. Have users set up as full data
users, but the save icon and save under file are grayed out. It will not let
her save data. I went through the users and made sure everything was checked
except design.

Author
27 Oct 2007 7:15 AM
'69 Camaro
Hi, Briklyn.

> Just changed to permissions in a database. Have users set up as full data
> users, but the save icon and save under file are grayed out. It will not
> let
> her save data.

The "Save" icon on the toolbar and the "Save" item in the menu are for
saving design changes of objects, not saving a record or a change to a
record.  If you want the users to be able to save a new record or a change
to an existing record, place a "Save" button on the form bound to the query
of the table, and add appropriate VBA code to the button's OnClick( ) event.

> I went through the users and made sure everything was checked
> except design.

Then it's working as you designed it.  The users can't save their design
changes.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.