Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nlocklin
Yak Posting Veteran
69 Posts |
 Posted - 2005-04-22 : 11:27:41
|
| I am trying to find out if it is possible to use windows domain account to authenticate users in Microsoft Access (2000 and/or 2003). What I would like to do is be able to restrict creating/changing queries etc. to certain users based on their domain login. Is this possible? Thanks in advance!--"It's not that I'm lazy... it's that I just don't care." |
|
|
bferriter
Starting Member
34 Posts |
Posted - 2005-04-22 : 16:46:41
|
| if you have multiple users, then you are using a SQL server backend? you can specify a single group from the domain controller in the SQL security tab. then use active directory on the domain controller to add users to the group so when they log into the domain from any computer their account with authenticate to the server and allow access to connect to it. |
 |
|
|
nlocklin
Yak Posting Veteran
69 Posts |
Posted - 2005-04-29 : 14:50:35
|
| We are using linked tables from a SQL Server database. I have assigned permissions in SQL Server, but that is not what I am concerned about here. I am specifically asking about restricting permissions in the Microsoft Access database to prevent users from changing other users queries, etc.--"It's not that I'm lazy... it's that I just don't care." |
|
|
|
bferriter
Starting Member
34 Posts |
Posted - 2005-04-29 : 14:52:48
|
| By what method are you giving access to queries? How do you have specific queries for different users set up?--------------------BrianOne man with 5 hats. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-04-29 : 15:13:36
|
| I would suggest converting to .adp this will give you real control from the server side.JimUsers <> Logic |
|
|
|
nlocklin
Yak Posting Veteran
69 Posts |
Posted - 2005-05-04 : 11:38:59
|
| I have a Microsoft Access database (.mdb) on a share for users. Within the Access database, I created linked tables using ODBC to connect to SQL Server using Windows authentication. All users have read-only access to the database.The SQL Server part of it doesn't really matter. Users need to be able to create their own queries, but in Microsoft Access only - I don't want people creating views in SQL Server or interacting with SQL Server any other way than having read-only access to these linked tables within the Access database.What I'd like to be able to do in the Access database is have only some users have the ability to create queries in the Access database. Is there a way to do this with the user's domain login?--"It's not that I'm lazy... it's that I just don't care." |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-05-04 : 12:04:51
|
| not really, security in Access doesn't work that way. If you use an MDW file you might be able to do it, but it can be tough to implement and maintain.Another option is to make the MDB file on the network read-only, and tell users if they want to write their own queries they need to copy it locally to their C:\ drive or somewhere like that. Then they can do whatever they want w/o messing up the other users. (plus you will get better performance when writing/saving/changing objects in the mdb file). You could write a front-end application that does this for them.- Jeff |
|
|
|
|
|
|
Using domain accounts in Access