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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
news:4ad724bb$(E-Mail Removed)...
> "Roger Tregelles" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
news:4ad735b9$(E-Mail Removed)...
> "Roger Tregelles" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
news:4ad74487$(E-Mail Removed)...
> "Roger Tregelles" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Roger Tregelles" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.

"Roger Tregelles" wrote:

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