Access ULS?

13 Jun 2006 2:54 PM

NeoDude0

I was referred to this newsgroup from microsoft.public.access, where I
started this topic:

> My "job" for this summer is to work on an Access database to track
> information about first responders or people with skills that could be
> useful in a crisis. The catch is, my goal is to not have to enter that
> information myself. What I'm supposed to be doing is creating a way for
> people to get into the database and access only their own record in the
> table of people, and then having one or more "administrator" sign-in
> accounts that have full access. My current server hosting is running
> Linux,
> so I'd be stuck with mySQL, but I may be able to get a Windows hosted
> package if I need to. Is there any way this can be done?

I got this response:

> If you were to use Access mdb as a backend, one of the ways to handle this
> to implement the Access User Level Security (ULS) and use RWOP queries.
> Access ULS is not for the faint of heart, you would need to invest
> significant time to do it correctly. Browse the ms-access security for
> more
> information.
>
> If you were to use a back end other than Access, you would obviously have
> to
> learn how to implement this within the chosen backend. Each back end has
> its
> own way of implementing what you're asking for.

Can I get help with this feature for an Access database? (I don't think my
Office XP MOS certs covered this...)

-Neo

13 Jun 2006 3:10 PM

Lynn Trapp

Neo,
You need to get the Security FAQ, read it several times, and follow it to
the letter. Don't skip any steps or you will either end up with an unsecured
database or a database that not even you can get into. There is a link to it
on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

Show quoteHide quote

"NeoDude0" <alanbunt***@hotmail.com> wrote in message
news:BD640901-3C00-40CA-9EF1-3FE3006E2A2C@microsoft.com...
>I was referred to this newsgroup from microsoft.public.access, where I
>started this topic:
>
>> My "job" for this summer is to work on an Access database to track
>> information about first responders or people with skills that could be
>> useful in a crisis. The catch is, my goal is to not have to enter that
>> information myself. What I'm supposed to be doing is creating a way for
>> people to get into the database and access only their own record in the
>> table of people, and then having one or more "administrator" sign-in
>> accounts that have full access. My current server hosting is running
>> Linux,
>> so I'd be stuck with mySQL, but I may be able to get a Windows hosted
>> package if I need to. Is there any way this can be done?
>
> I got this response:
>
>> If you were to use Access mdb as a backend, one of the ways to handle
>> this
>> to implement the Access User Level Security (ULS) and use RWOP queries.
>> Access ULS is not for the faint of heart, you would need to invest
>> significant time to do it correctly. Browse the ms-access security for
>> more
>> information.
>>
>> If you were to use a back end other than Access, you would obviously have
>> to
>> learn how to implement this within the chosen backend. Each back end has
>> its
>> own way of implementing what you're asking for.
>
> Can I get help with this feature for an Access database? (I don't think
> my Office XP MOS certs covered this...)
>
> -Neo