Kumar- No. But it is possible to hide the database window and get rid of the built-in toolbars by setting options in Tools / Startup. You should define custom menus and toolbars for any form that opens in the application. You can also define and set the AllowBypassKey property (look it up in help) to prevent users from bypassing Startup settings by holding down the Shift key.
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: Tuesday, November 22, 2005 1:49 AM To: [email protected] Subject: [ms_access] Re: Locking Table for Data Entry or editing John, Thanks for the prompt help. It is working. One more question, is it possible to load only the form and hide the access program with its menus and the database window? I want to display just the form while launching a mde similar to Visual basic exe. The users should have access only to the command buttons on the form. Thanks and Regards, Kumar --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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 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/
