Access lock cells

J

James

I have a table that has some cells in it locked where a user cannot type in it. How can I reverse the lock so my users can type in it? I have looked around in access but there is nothing obvious to make all the cells in a table editable.

Thanks,
James
 
C

Chris O'C via AccessMonster.com

Is it a Jet table or is it linked table for a file in a different format?
Not all drivers allow editing of a linked table. HTML is one of them.

If it's a Jet table with a locked datasheet, the developer used a tool to
lock it because users were editing the table directly - instead of using the
form, which is the correct method for data input. Either get the developer
to use the same tool to unlock the datasheet or buy another copy of it so you
can lock/unlock the table when you want to.

Chris
Microsoft MVP
 
Top