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 |
|
abansal
Starting Member
4 Posts |
 Posted - 2004-05-26 : 16:02:54
|
| I'm not sure if this can be done, but any help would be much appreciated. I have a SQLServer database that someone can access using an Access Form. I want to be able to have read/write access when i go through the Enterprise Manager, but I only want read access when the user accesses the information using the Access Form. Also, when I upload the information to the SQL Server, i get the information and store them in temp Access MDB files (different from the ones used to access the information) so that I can run any queries on them. i then upload the data to the SQL Server using linked tables. What I want is to have one Access DMB file to have read only access, while the other one is able to upload the informaiton onto the SQL Server. |
|
|
sorengi
Starting Member
48 Posts |
Posted - 2004-05-26 : 16:12:25
|
| When you link the tables from SQL Server to Access, do not select a primary key, just hit cancel, and you will then be unable to upate any records in the SQL Server database from Access (Read-Only)Michael D. |
 |
|
|
sorengi
Starting Member
48 Posts |
Posted - 2004-05-26 : 16:15:55
|
| Of course the other option is to use SQL Server security and connect to SQL Server via Access with a user in the "db_datareader" role, and connect via EM with a user in the "db_datareader" and "db_datawriter" roles...Michael D. |
|
|
|
abansal
Starting Member
4 Posts |
Posted - 2004-05-27 : 14:32:58
|
| I prefer to use SQL Server security...I'm thinking that maybe i will have the code use an admin account to upload the information to the SQL Server where as other access to the SQL Server will be set to a Guest or User account. I'm a newbie to SQL Server, so I'm currently reading up on how to do that. |
|
|
|
|
|
|
Set permissions in SQL Server