question ... query and filtering

  • Thread starter Thread starter Andy_HR
  • Start date Start date
A

Andy_HR

i have declared in module some "strings" (i think thats correct word for it
please correct me... ) like this

Global Transfer, Data, user....

now when user logs in when he/her enters username and clicks OK button it
cheks for password if password is ok then i goes to this sub

Sub login_ok
USER = Me!username
docmd.openform "Menu_1"
End sub

now i would like query to use te USER as a criteria for filtering all the
records that this user made and print a report with it... now i have this
working but current loged in user is write in one table with a maketable
query and i use info from there... but now we will have to install this app
on terminal server and this wont work anymore...

i dont want to use access built in security cose if i add another user then
i have to go to all computers and ad the same user there (i did pute mdw
file on the network share but if the connection is not established with
network share then user automaticly logs in as admin and i dont want that)
the app must be flexible so any user can sit at any comp and use this
aplication

(all data is stored on sql server)

tnx in advance

-
andy
 
Andy_HR said:
i have declared in module some "strings" (i think thats correct word for it
please correct me... ) like this

Global Transfer, Data, user....

now when user logs in when he/her enters username and clicks OK button it
cheks for password if password is ok then i goes to this sub

Sub login_ok
USER = Me!username
docmd.openform "Menu_1"
End sub

now i would like query to use te USER as a criteria for filtering all the
records that this user made and print a report with it... now i have this
working but current loged in user is write in one table with a maketable
query and i use info from there... but now we will have to install this app
on terminal server and this wont work anymore...

i dont want to use access built in security cose if i add another user then
i have to go to all computers and ad the same user there (i did pute mdw
file on the network share but if the connection is not established with
network share then user automaticly logs in as admin and i dont want that)
the app must be flexible so any user can sit at any comp and use this
aplication

(all data is stored on sql server)
Click to expand...

If the data is stored on SQL Server you can create user accounts on SQL
Server. Open Enterprise Manager and look at the Security node under the
database tree. Set up SQL Server to use NT logon info and set your
Connection string to include the parameter "Trusted_Connection=Yes" (and
remove any Pwd=???;UID=??? parameters). Use the User_Name() or
User_ID() functions to get the name/id of current-session user. Don't
allow any user direct access to tables. Use database Roles to assign
access thru Views. Consider using SQL'r temp tables thru stored
procedures instead of local make-table queries.

Read the Access security FAQ whitepaper for general info on applying
security to databases:

http://support.microsoft.com/default.aspx?scid=kb;en-us;165009&Product=acc
 
MGFoster said:
If the data is stored on SQL Server you can create user accounts on SQL
Server. Open Enterprise Manager and look at the Security node under the
database tree. Set up SQL Server to use NT logon info and set your
Connection string to include the parameter "Trusted_Connection=Yes" (and
remove any Pwd=???;UID=??? parameters). Use the User_Name() or
User_ID() functions to get the name/id of current-session user. Don't
allow any user direct access to tables. Use database Roles to assign
access thru Views. Consider using SQL'r temp tables thru stored
procedures instead of local make-table queries.

Read the Access security FAQ whitepaper for general info on applying
security to databases:

http://support.microsoft.com/default.aspx?scid=kb;en-us;165009&Product=acc
Click to expand...

i would but for now i cant... it will be possible in 2 months but for now..
it is not.. becouse some users are running under guest account.. and the
complete network is going to be built from the scratch.. so i have to use
this way off doing it...

-
andy
 
Back
Top