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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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