Prevent 'Edit... Delete Record...' capability? Pat Dools 05.02.2006 16:11:27 Hello, I have gone into the 'Startup...' menu and de-selected showing the Database window, 'Allow Full Menus', 'Allow Default Shortcut Menus', and 'Allow Built-in Toolbars', but users, while entry data into a form, can still go to the 'Edit..' menu and select 'Delete Record'. I do not want them to be able to do this. How can I disable this capability? Thanks. -- Pat Dools

Re: Prevent 'Edit... Delete Record...' capability? "Joan Wild" <jwild[ at ]nospamtyenet.com> 05.02.2006 16:26:45 You could always set the Allow Deletions property of the form to No. Then make a MDE from your MDB and give that to the users (be sure to keep a copy of the MDB in case you need to make more changes). Other than that, you should also consider creating your own custom menus/toolbars that don't include commands you don't want them to have. -- Joan Wild Microsoft Access MVP Pat Dools wrote: [Quoted Text] > Hello, > > I have gone into the 'Startup...' menu and de-selected showing the > Database window, 'Allow Full Menus', 'Allow Default Shortcut Menus', > and 'Allow Built-in Toolbars', but users, while entry data into a > form, can still go to the 'Edit..' menu and select 'Delete Record'. > I do not want them to be able to do this. How can I disable this > capability? > > Thanks. > -- > Pat Dools

Re: Prevent 'Edit... Delete Record...' capability? Pat Dools 06.02.2006 03:45:27 Great, thank you, Joan. Do you happen to have a URL or white paper that has like an 'FAQ' for security questions for Access 2002-2003? That would be a great thing to have. Thanks again. -- Pat Dools "Joan Wild" wrote: [Quoted Text] > You could always set the Allow Deletions property of the form to No. > > Then make a MDE from your MDB and give that to the users (be sure to keep a > copy of the MDB in case you need to make more changes). > > Other than that, you should also consider creating your own custom > menus/toolbars that don't include commands you don't want them to have. > > > -- > Joan Wild > Microsoft Access MVP > > Pat Dools wrote: > > Hello, > > > > I have gone into the 'Startup...' menu and de-selected showing the > > Database window, 'Allow Full Menus', 'Allow Default Shortcut Menus', > > and 'Allow Built-in Toolbars', but users, while entry data into a > > form, can still go to the 'Edit..' menu and select 'Delete Record'. > > I do not want them to be able to do this. How can I disable this > > capability? > > > > Thanks. > > -- > > Pat Dools > > >

Re: Prevent 'Edit... Delete Record...' capability? "Lynn Trapp" <ltrapp_NOSPAM[ at ]ltcomputerdesigns.com> 06.02.2006 13:19:37 You can find a link to the Security FAQ at http://www.jmwild.com/Accesssecurity.htm or on the Security page of my website. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html "Pat Dools" <PatDools[ at ]discussions.microsoft.com> wrote in message news:BF9D6C9F-D036-426F-BFDE-4C7D5865BDFD[ at ]microsoft.com... [Quoted Text] > Great, thank you, Joan. Do you happen to have a URL or white paper that > has > like an 'FAQ' for security questions for Access 2002-2003? That would be > a > great thing to have. > > Thanks again. > -- > Pat Dools > > > "Joan Wild" wrote: > >> You could always set the Allow Deletions property of the form to No. >> >> Then make a MDE from your MDB and give that to the users (be sure to keep >> a >> copy of the MDB in case you need to make more changes). >> >> Other than that, you should also consider creating your own custom >> menus/toolbars that don't include commands you don't want them to have. >> >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Pat Dools wrote: >> > Hello, >> > >> > I have gone into the 'Startup...' menu and de-selected showing the >> > Database window, 'Allow Full Menus', 'Allow Default Shortcut Menus', >> > and 'Allow Built-in Toolbars', but users, while entry data into a >> > form, can still go to the 'Edit..' menu and select 'Delete Record'. >> > I do not want them to be able to do this. How can I disable this >> > capability? >> > >> > Thanks. >> > -- >> > Pat Dools >> >> >>

Re: Prevent 'Edit... Delete Record...' capability? Pat Dools 06.02.2006 14:18:27 Thank you, guys! I really appreciate it! Patrick -- Pat Dools "Lynn Trapp" wrote: [Quoted Text] > You can find a link to the Security FAQ at > http://www.jmwild.com/Accesssecurity.htm or on the Security page of my > website. > > -- > Lynn Trapp > MS Access MVP > www.ltcomputerdesigns.com > Access Security: www.ltcomputerdesigns.com/Security.htm > Jeff Conrad's Access Junkie List: > http://home.bendbroadband.com/conradsystems/accessjunkie.html > > > > "Pat Dools" <PatDools[ at ]discussions.microsoft.com> wrote in message > news:BF9D6C9F-D036-426F-BFDE-4C7D5865BDFD[ at ]microsoft.com... > > Great, thank you, Joan. Do you happen to have a URL or white paper that > > has > > like an 'FAQ' for security questions for Access 2002-2003? That would be > > a > > great thing to have. > > > > Thanks again. > > -- > > Pat Dools > > > > > > "Joan Wild" wrote: > > > >> You could always set the Allow Deletions property of the form to No. > >> > >> Then make a MDE from your MDB and give that to the users (be sure to keep > >> a > >> copy of the MDB in case you need to make more changes). > >> > >> Other than that, you should also consider creating your own custom > >> menus/toolbars that don't include commands you don't want them to have. > >> > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> > >> Pat Dools wrote: > >> > Hello, > >> > > >> > I have gone into the 'Startup...' menu and de-selected showing the > >> > Database window, 'Allow Full Menus', 'Allow Default Shortcut Menus', > >> > and 'Allow Built-in Toolbars', but users, while entry data into a > >> > form, can still go to the 'Edit..' menu and select 'Delete Record'. > >> > I do not want them to be able to do this. How can I disable this > >> > capability? > >> > > >> > Thanks. > >> > -- > >> > Pat Dools > >> > >> > >> > > >

Re: Prevent 'Edit... Delete Record...' capability? Li Qiu 01.09.2006 21:59:02 Hi Joan, I set the "Allow Deletions" property of the form to No and made a MDE file. In the Tool -> Startup, all checkboxes are unchecked. However, the edit -> delete record in microsoft window menu still can delete the record in the form. My system is Access 2002 run on window XP professional. Would you please help me out. Thanks a lot. Li Qiu "Joan Wild" wrote: [Quoted Text] > You could always set the Allow Deletions property of the form to No. > > Then make a MDE from your MDB and give that to the users (be sure to keep a > copy of the MDB in case you need to make more changes). > > Other than that, you should also consider creating your own custom > menus/toolbars that don't include commands you don't want them to have. > > > -- > Joan Wild > Microsoft Access MVP > > Pat Dools wrote: > > Hello, > > > > I have gone into the 'Startup...' menu and de-selected showing the > > Database window, 'Allow Full Menus', 'Allow Default Shortcut Menus', > > and 'Allow Built-in Toolbars', but users, while entry data into a > > form, can still go to the 'Edit..' menu and select 'Delete Record'. > > I do not want them to be able to do this. How can I disable this > > capability? > > > > Thanks. > > -- > > Pat Dools > > >

Re: Prevent 'Edit... Delete Record...' capability? "Joan Wild" <jwild[ at ]nospamtyenet.com> 02.09.2006 13:52:33 I cannot reproduce this. If you set the Allow deletions to 'no', then the Edit - delete record menu item is disabled here. Tested in 2002 on WinXP. -- Joan Wild Microsoft Access MVP Li Qiu wrote: [Quoted Text] > Hi Joan, > > I set the "Allow Deletions" property of the form to No and made a MDE > file. In the Tool -> Startup, all checkboxes are unchecked. However, > the edit -> delete record in microsoft window menu still can delete > the record in the form. My system is Access 2002 run on window XP > professional. > Would you please help me out. > > Thanks a lot. > Li Qiu > > "Joan Wild" wrote: > >> You could always set the Allow Deletions property of the form to No. >> >> Then make a MDE from your MDB and give that to the users (be sure to >> keep a copy of the MDB in case you need to make more changes). >> >> Other than that, you should also consider creating your own custom >> menus/toolbars that don't include commands you don't want them to >> have. >> >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Pat Dools wrote: >>> Hello, >>> >>> I have gone into the 'Startup...' menu and de-selected showing the >>> Database window, 'Allow Full Menus', 'Allow Default Shortcut Menus', >>> and 'Allow Built-in Toolbars', but users, while entry data into a >>> form, can still go to the 'Edit..' menu and select 'Delete Record'. >>> I do not want them to be able to do this. How can I disable this >>> capability? >>> >>> Thanks. >>> -- >>> Pat Dools