Disable Workgroup Security in 2003 DB for 2007 SP

  • Thread starter Thread starter Roger Tregelles
  • Start date Start date
R

Roger Tregelles

I have a few databases that I created in Access 2003 and used workgroup
security with the workgroup file up on a network share. We have now upgraded
to Access 2007 and am also using SharePoint. I want to disable the
workgroup security on these databases so that I can move them up to
SharePoint which will control the security for me. Does anyone know how to
do this or can point me in the right direction? I no longer have Access 2003
loaded on my PC only Office 2007 now too. Thanks in advance for any and all
help provided.
 
Roger Tregelles said:
I have a few databases that I created in Access 2003 and used workgroup
security with the workgroup file up on a network share. We have now
upgraded to Access 2007 and am also using SharePoint. I want to disable
the workgroup security on these databases so that I can move them up to
SharePoint which will control the security for me. Does anyone know how to
do this or can point me in the right direction? I no longer have Access
2003 loaded on my PC only Office 2007 now too. Thanks in advance for any
and all help provided.
Click to expand...

Give the "users" group full permissions to all of the database objects
including the database itself then import all of the objects into a new,
blank database file.

Keith.
www.keithwilby.co.uk
 
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.

Roger Tregelles
 
Roger Tregelles said:
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.
Click to expand...

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
 
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
 
Roger Tregelles said:
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
Click to expand...

I am not too familiar with A2007 and it is not on the machine I am working
on now but AIUI ULS is supported in A2007 provided that you stick to the
"mdb" file format. I have A2007 on another machine which I will look at
tonight and report back if no one else responds in the meantime.

Keith.
 
Hi Keith,

That would be great if you could please let me know what you find out in
Access 2007, thanks so much.

Roger Tregelles
 
Hi Keith,

Thanks so much for showing me how to do this in Access 2007. I'll give this
a try and hopefully I can get it to work properly as a new database and
uploaded to SharePoint. Thanks again for all of your help with this, I
really appreciate it.

Roger Tregelles
 
Roger Tregelles said:
Hi Keith,

Thanks so much for showing me how to do this in Access 2007. I'll give
this a try and hopefully I can get it to work properly as a new database
and uploaded to SharePoint. Thanks again for all of your help with this, I
really appreciate it.

Roger Tregelles
Click to expand...

Thanks for the feedback, glad to help if I can.
 
Roger Tregelles said:
I have a few databases that I created in Access 2003 and used workgroup
security with the workgroup file up on a network share. We have now upgraded
to Access 2007 and am also using SharePoint. I want to disable the
workgroup security on these databases so that I can move them up to
SharePoint which will control the security for me. Does anyone know how to
do this or can point me in the right direction? I no longer have Access 2003
loaded on my PC only Office 2007 now too. Thanks in advance for any and all
help provided.


.
Click to expand...
 
Roger Tregelles said:
I have a few databases that I created in Access 2003 and used workgroup
security with the workgroup file up on a network share. We have now upgraded
to Access 2007 and am also using SharePoint. I want to disable the
workgroup security on these databases so that I can move them up to
SharePoint which will control the security for me. Does anyone know how to
do this or can point me in the right direction? I no longer have Access 2003
loaded on my PC only Office 2007 now too. Thanks in advance for any and all
help provided.


try creating a new database and import the objects
Click to expand...
 
Back
Top