My guess, for whatever that may be worth, would be that if the user doesn't
have explicit permission on the table, the user probably has implicit
permission through membership of a group that has such permission. But I'm
not the best person to answer security questions. If no one else responds
here, try asking in microsoft.public.access.security
--
Brendan Reynolds (MVP)
"Robert" <(E-Mail Removed)> wrote in message
news:5E4FE6F4-E7D2-4D19-871D-(E-Mail Removed)...
> Using the information at this link does indeed open and read the table
> information. However I have not given any permissions for the user. This
> still ignors the security settings. I need to connect and have the
> connection use the security setting set up in the database thats opening.
> How can this be accomplished?
>
>
>
> "Brendan Reynolds" wrote:
>
>> Here's a link to a recent thread on the same subject in the Google
>> archive
>> ....
>> http://groups-beta.google.com/group/...403c1597f3b0c7
>>
>> --
>> Brendan Reynolds (MVP)
>>
>>
>> "Robert" <(E-Mail Removed)> wrote in message
>> news:1731AA2B-5CF5-482F-8385-(E-Mail Removed)...
>> > When I use this connect string it gives me an error message that the
>> > workgroup file is missing or opened exclusive.
>> >
>> > "Alex Dybenko" wrote:
>> >
>> >> i tried to build connection string using udl file, and it looks like:
>> >>
>> >> Provider=Microsoft.Jet.OLEDB.4.0;Password=MyPass;User ID=MyUSer;Data
>> >> Source=C:\db1.mdb;Persist Security Info=True
>> >>
>> >>
>> >> --
>> >> Alex Dybenko (MVP)
>> >> http://Alex.Dybenko.com
>> >> http://www.PointLtd.com
>> >>
>> >>
>> >>
>> >> "Robert" <(E-Mail Removed)> wrote in message
>> >> news:526068B4-830B-429E-8D35-(E-Mail Removed)...
>> >> > When I use a ado connect string it ignors the UID and PWD in the
>> >> > connect
>> >> > string and uses the user admin. How can I get the ADO connection to
>> >> > use
>> >> > the
>> >> > user name and password I have specified in the connect string?
>> >>
>> >>
>> >>
>>
>>
>>
Similar Threads
