Disable Workgroup Security in 2003 DB for 2007 SP

[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.

 

[Keith Wilby]

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.

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

 

[Roger Tregelles]

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

 

[Keith Wilby]

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

 

[Roger Tregelles]

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]

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

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.

 

[Roger Tregelles]

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

 

[Keith Wilby]

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

On the ribbon, click the "database tools" tab then use the "users and
permissions" button under "administer.

Keith.

 

[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

 

[Keith Wilby]

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

Thanks for the feedback, glad to help if I can.

 

[jj]

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.


.

 

[jj]

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