Re: Disable Workgroup Security in 2003 DB for 2007 SP

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Keith,

Thanks again for the reply. I am familiar with how to do this in Access
2003, but I no longer have this loaded on my PC. How would I do this same
thing in Access 2007 which no longer uses the workgroup security model? Any
help you could provide me would be appreciated, thanks.

Roger Tregelles


"Keith Wilby" <here@xxxxxxxxx> wrote in message
news:4ad735b9$1_1@xxxxxxxxxxxxxxxxxxxxxxxxx
"Roger Tregelles" <roger.tregelles@xxxxxxxxxxx> wrote in message
news:ec88CAaTKHA.220@xxxxxxxxxxxxxxxxxxxxxxx
Hi Keith,

Thanks so much for the reply. How exactly would I "Give the "users" group
full permissions to all of the database objects including the database
itself" and also "import all of the objects into a new, blank database
file." Any help you could provide would be greatly appreciated. Thanks
again.



Hello Roger,

I assumed you'd be familiar with these terms given that you stated that
you'd worked with ULS and workgroups. If that's not the case then I'd
highly recommend that you download and study the MS FAQ which will tell
you all you need to know. There's a link to it on my web site.

In a nutshell, you'd go to Tools, Security, Permissions to grant all to
the "users" group.

Keith.
www.keithwilby.co.uk


.

Relevant Pages

  • Re: Security to document databases
    ... The default public permissions should provide the needed permissions in SQL ... 2000 to view schema. ... there are many third party tools that can help automate database ... their ability to get a list of database objects in enterprise manager. ...
    (microsoft.public.sqlserver.security)
  • Re: Setting up Authorizations for on-Form data entry: Advice requ
    ... Yes I was talking about logging onto the database. ... permissions for all existing database objects and ones that will be created ... Newly created users are automatically added to the Users group (which ... database file can edit or delete database objects, ...
    (microsoft.public.access.formscoding)
  • Re: Setting up Authorizations for on-Form data entry: Advice requ
    ... Yes I was talking about logging onto the database. ... permissions for all existing database objects and ones that will be created ... Newly created users are automatically added to the Users group (which ... database file can edit or delete database objects, ...
    (microsoft.public.access.formscoding)
  • Opening a database file...
    ... This I think is irrelevant though as I cannot open it because of the permissions etc that were on the file. ... "You can't make changes to the database objects in the database 'filename.' ... she's been screaming down the phone today asking why she can't access her database. ...
    (microsoft.public.access.security)
  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)