I would like to have a different startup query for each of my users. For example if I have the users: user1,user2, and User3 I would like to have query1 run when user1 loggs in and when user2 loggs in then query2 would run. I have already ran the User-Level Security Wizard on this database. I am not sure how to do this.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running queries on login
- Thread starter darkmage1
- Start date
I guess if I had to do something like this I would create a table:
UserID SQLStatement
user1 SELECT * FROM Table1
user2 SELECT * FROM Table2
user3 SELECT * FROM Table3
then I would get the SQLstatement field based on the user id and pass that through.
Just curious, why would you need to do this?
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases: The Fundamentals of Relational Database Design
UserID SQLStatement
user1 SELECT * FROM Table1
user2 SELECT * FROM Table2
user3 SELECT * FROM Table3
then I would get the SQLstatement field based on the user id and pass that through.
Just curious, why would you need to do this?
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases: The Fundamentals of Relational Database Design
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question