access 2003 with linked sqlserver 200o tables - views - current odbc user

[F. Mobile]

Hi,

I have an access 2003 mdb running with linked sql server 2003 tables and
views.
10 users get that application. On every users pc I creat an odbc connection
to my sqlserver with an different user and password.
Every user needs different forms and different sqlserver 2000 views.
Is that also in access basic possible? How?



Therefore I want in Access Basic 2003 query at programm start which odbc
user is running my application.
I found in the internet that I can make that with an pass through query.
(Select suser_sname(suser_sid())
But I don't know the exactly code.
Depending on the user should form1 to form10 be opened.

Can anybody show me the access basic code for that -please!

Thanks

 

[Jerry Porter]

The following works for me:

select user_name(user_id())