User Level Security allowing External Queries

[Guest]

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.

 

[Joan Wild]

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.

 

[Guest]

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

 

[Guest]

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.

 

[Joan Wild]

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

 

[Guest]

That is how it is now, but when I try and write a query from Excel, and I
look at the Access Database, I can see the tables but it won't let me drop
down select any fields.

 

[Joan Wild]

Do you get an error message? What happens?