Re: User Level Security allowing External Queries

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In order for it to work,you can give the Users Group open permission on the
database object, and read data permissions on the table(s).

--
Joan Wild
Microsoft Access MVP
"Darren Aiello" <DarrenAiello@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0F60F5E6-1086-4C11-B2B0-505934EC96A3@xxxxxxxxxxxxxxxx
As a follow-up, a user of another Access Database can query into my
database,
but it will not allow Excel to do so. I think it has to do with actually
being "logged in" under teh users group as long as Access is open.

I still need Excel to work.

"Darren Aiello" wrote:

I don't care who looks at the data, I only care who changes stuff.

"Joan Wild" wrote:

You can grant open permission on the database object, and read data
permission on the tables in the mdb.

However there wouldn't be much point in securing the mdb if you're
going to
do that.

--
Joan Wild
Microsoft Access MVP
"Darren Aiello" <Darren Aiello@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:53801430-E16B-4F99-8685-69740DCE779F@xxxxxxxxxxxxxxxx
I am trying to set up a database with User Level Security.
I have given read access to the User's group and Full access to a
generic
password protected profile that is distributed to those who need it.
What I am havign trouble doing is allowing anyone (the Users group)
to
query
into my database from an external application (specifically Excel
although
I
intend to create other access applications that will need to
reference
this
database).
How can I do this? I don't seem to be able to find a simple solution
although I am sure there is one.





.

Relevant Pages

  • Re: Secure shortcut Unsecure File
    ... The users group has permission to open/run in the ... Database object type. ... you have a shortcut with the following in the target: ...
    (microsoft.public.access.security)
  • Re: Hlp - DB security mystery
    ... Joan Wild ... I triple checked the mdw and the Users group has NO ... to secure, including creating a brand new mdw. ... The database in on a network share to which only my group and I have access. ...
    (microsoft.public.access.security)
  • Re: Switchboard security
    ... Microsoft Access MVP ... uses the same database) can only access certain forms/reports/tables. ... permission to run "blah blah". ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)
  • Re: Access 2003 - Security
    ... Joan Wild ... Microsoft Access MVP ... users group are able to open the database without a problem. ...
    (microsoft.public.access.security)
  • Re: Workgroup files and Open/Run in 2002
    ... >> permission should be explicitly removed. ... The "Database" object handles this. ... If you have zero permissions to the ... >> It is a requirement that all users be in the Users group but this is ...
    (microsoft.public.access.security)