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 |
|
juno
Starting Member
11 Posts |
 Posted - 2003-10-01 : 17:11:57
|
| I am not sure if this is possible.What I am trying to do is to prevent the users form opening the database directly. The only way they would be able to make changes to the database is via Forms. I do not want the users to type in any passwords as long as they have the Form. In order words, I will create different Forms (Edit Form, ReadOnly Form) then I will distribute this Forms. If the user has the ReadOnly Form he/she will be limited as to what they can do. However the database would be protected from anyone who wants to open it without a form. |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-10-01 : 17:21:19
|
| I think if you separate the data from the forms into two separate MDB files, you can do this.You can password protect the "data" MDB and then "link" the "Forms" MDB to the data MDB.Does that make sense?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-10-01 : 17:32:45
|
| Access has a full security model; it can be a little clunky in the way it uses MDW files but you can do all of those things quite easily.So, you didn't really pose a question, but it is very possible and pretty easy. you will need to either have everyone join the same workgroup (read about it in HELP), and/or create a shortcut for everyone that opens your DB using the workgroup as a parameter. If they don't use the shortcut, which requires them to log into the workgroup, they won't be able to even open up the database if you set up the security correctly.- Jeff |
|
|
|
juno
Starting Member
11 Posts |
Posted - 2003-10-01 : 17:42:43
|
| It makes sense but when i try doing that it did't work :( |
|
|
|
|
|
|
Database Security question