From: JeffP on
I have a 2000 database that users ULS for restricting access to forms and
reports.

What is the best, or any, solution for restricting access to forms and
reports in 2007 which doesn't support ULS?



From: Tony Toews [MVP] on
"JeffP" <no-reply(a)asken.com.au> wrote:

>I have a 2000 database that users ULS for restricting access to forms and
>reports.
>
>What is the best, or any, solution for restricting access to forms and
>reports in 2007 which doesn't support ULS?

A2007 still supports ULS in MDB file format. You do give up the user of the new
field types such as multi valued fields which are only available in ACCDB file
format.

T
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
From: Tom van Stiphout on
On Wed, 26 May 2010 09:44:25 +1000, "JeffP" <no-reply(a)asken.com.au>
wrote:

If you are on a domain, you can use the techniques discussed here:
http://www.accesssecurityblog.com/post/Securing-Access-databases-using-Active-Directory.aspx

-Tom.
Microsoft Access MVP


>I have a 2000 database that users ULS for restricting access to forms and
>reports.
>
>What is the best, or any, solution for restricting access to forms and
>reports in 2007 which doesn't support ULS?
>
>
From: JeffP on
Not on a domain Tom. Only on a local network.

"Tom van Stiphout" <tom7744.no.spam(a)cox.net> wrote in message
news:u3uov51sun9g2sh13lge6sog42qubeh286(a)4ax.com...
> On Wed, 26 May 2010 09:44:25 +1000, "JeffP" <no-reply(a)asken.com.au>
> wrote:
>
> If you are on a domain, you can use the techniques discussed here:
> http://www.accesssecurityblog.com/post/Securing-Access-databases-using-Active-Directory.aspx
>
> -Tom.
> Microsoft Access MVP
>
>
>>I have a 2000 database that users ULS for restricting access to forms and
>>reports.
>>
>>What is the best, or any, solution for restricting access to forms and
>>reports in 2007 which doesn't support ULS?
>>
>>


From: JeffP on
It is already a 2007 format database Tony. No going back.

"Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote in message
news:2sqov5li5e4r6j75bn18g2gd2a3n11d0gi(a)4ax.com...
> "JeffP" <no-reply(a)asken.com.au> wrote:
>
>>I have a 2000 database that users ULS for restricting access to forms and
>>reports.
>>
>>What is the best, or any, solution for restricting access to forms and
>>reports in 2007 which doesn't support ULS?
>
> A2007 still supports ULS in MDB file format. You do give up the user of
> the new
> field types such as multi valued fields which are only available in ACCDB
> file
> format.
>
> T
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> For a convenient utility to keep your users FEs and other files
> updated see http://www.autofeupdater.com/
> Granite Fleet Manager http://www.granitefleet.com/