Kumar- Open the database to the database window. Choose Tools / Security / User and Group Permissions.
Choose Object Type Table, select the table in the list, and clear the Update Data, Insert Data, and Delete Data check boxes for the Admin user and apply the changes. Select the Groups list and the Users group and clear the same check boxes and apply the changes. A really sharp user could go to this security dialog and re-enable these permissions, but this will at least prevent "accidental" changes to your table. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of access_kri Sent: Monday, November 21, 2005 12:20 PM To: [email protected] Subject: [ms_access] Looking Table for Data Entry or editing Dear All, Is there a way to prevent any changes to table data or adding new record to the table. I have designed an Engineering Table which contains standard dimensions for a given valve size and rating. The table is based on relevant Standards and it cannot grow as all the possible sizes are covered. I have a form which requires users to select the size and rating and the other dimensions are displayed. The form selected is single form without any navigation buttons and does not allow data entry. However, I do not want to hide the table, but prevent any fiddling with the table data even accidently by me or any other user. Thanks in advance. Regards, Kumar ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
