Have an Access 2003 db which I am processing with Access 2010. What I want to do is add some rows to the end of an existing table. However there does not appear to be permission to do that. THe Insert button has been grayed out.
Am opening the db while holding down the Shift key, Then when I go to the File tab on the ribbon and choose Manager Security for Users and Groups I select the file and notice that all maint opions (Insert, Delete, etc) are grayed out. When I try to click these permissions for the table to allow an Insert the message is display like "To Change permissions for this object you must have Administir permissison for it.
So how do I modify the tabes which need update access ? How can I get this Administir access going for this table. Need to add data to the end of an existing data file today.