Login

[Tina]

Hello,

I am not sure if this is the right group to ask, if not,
could you tell me which group I should ask this question?

I have access database configured to use linked tables
with sql server database.
We haven't created any workgroups, so it doesn't ask for
any userid/pwd upon logon. However, when I run the form,
it asks for userid/pwd to validate against sql server
database. Now I would like to retain this sql server
userid/pwd for future use in my other forms.

My question is -
1. Upon logon it should ask for userid/pwd to validate
against sql server.
2. Upon successful logon, I would like to retain this
userid/pwd how can I do so?

Thanks in advance,
-Tina.

 

[TFERRY]

----- Tina wrote: ----

Hello

I am not sure if this is the right group to ask, if not
could you tell me which group I should ask this question

I have access database configured to use linked table
with sql server database
We haven't created any workgroups, so it doesn't ask fo
any userid/pwd upon logon. However, when I run the form
it asks for userid/pwd to validate against sql serve
database. Now I would like to retain this sql serve
userid/pwd for future use in my other forms

My question is
1. Upon logon it should ask for userid/pwd to validat
against sql server
2. Upon successful logon, I would like to retain thi
userid/pwd how can I do so

Thanks in advance
-Tina


I used to have Access linked to a SQL server, and it used ODBC links to get the necessary tables. These ODBC links were set up from Control Panel/Administrative Tools/Data Sources. These links used the SQL server's security when you pull data into Access. But Access only promted me once when i started using the database, and it allowed my continuous "access" to the linked data from that point on, as long as i did not leave Access. However, the next time I opened this database and wanted to pull data again, i would log in again
Does that help
Ti

 

[Tina]

Tim,

I already have linked tables and I am able to login
as well. My question is how can I capture user
credentital.

Example: I login as 'Tina/pwd'

I would like to use the username 'Tina' in my query
how can I use it. Like some packages have
something like $username this will retrieve the
name of the user who is logged on.

Hope this is clear now.

Thanks for your reply!
-Tina

-----Original Message-----


----- Tina wrote: -----

Hello,

I am not sure if this is the right group to ask, if not,
could you tell me which group I should ask this question?

I have access database configured to use linked tables
with sql server database.
We haven't created any workgroups, so it doesn't ask for
any userid/pwd upon logon. However, when I run the form,
it asks for userid/pwd to validate against sql server
database. Now I would like to retain this sql server
userid/pwd for future use in my other forms.

My question is -
1. Upon logon it should ask for userid/pwd to validate
against sql server.
2. Upon successful logon, I would like to retain this
userid/pwd how can I do so?

Thanks in advance,
-Tina.


I used to have Access linked to a SQL server, and it

used ODBC links to get the necessary tables. These ODBC
links were set up from Control Panel/Administrative
Tools/Data Sources. These links used the SQL server's
security when you pull data into Access. But Access only
promted me once when i started using the database, and it
allowed my continuous "access" to the linked data from
that point on, as long as i did not leave Access.
However, the next time I opened this database and wanted
to pull data again, i would log in again.