Showing posts with label connected. Show all posts
Showing posts with label connected. Show all posts

Thursday, March 22, 2012

CurrentProject.IsConnected is reporting on what?

Does CurrentProject.IsConnected tell me that the ADP is connected to the SQL
database, or that it sees the network?
I have an ACCESS ADP connecting to a SQL db via a wireless network. I
thought I would check CurrentProject.IsConnected to see if I had lost
connection due to out of wireless range, and if so, re connect to the DB via
code. But when I come back into range, this CurrentProject.IsConnected is
always true, but I am still not re-connected to the DB.
Any thoughts?
Thanks,
SteveTry posting to one of the Access newsgroups instead - try:
microsoft.public.access.adp.sqlserver
-Sue
On Tue, 11 Apr 2006 07:49:02 -0700, SteveInBeloit
<SteveInBeloit@.discussions.microsoft.com> wrote:

>Does CurrentProject.IsConnected tell me that the ADP is connected to the SQ
L
>database, or that it sees the network?
>I have an ACCESS ADP connecting to a SQL db via a wireless network. I
>thought I would check CurrentProject.IsConnected to see if I had lost
>connection due to out of wireless range, and if so, re connect to the DB vi
a
>code. But when I come back into range, this CurrentProject.IsConnected is
>always true, but I am still not re-connected to the DB.
>Any thoughts?
>Thanks,
>Steve

Current User

How can get the current user name/id of the connected user in Sql
Server 2005? I am using windows authentication. If I use USER or
CURRENT_USER function it always returns DBO and I am looking for the
network sign on which in my case would be URSC. Thanks.Try the ORIGINAL_LOGIN() function.
Hope this helps.
Dan Guzman
SQL Server MVP
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1150200242.086128.219900@.p79g2000cwp.googlegroups.com...
> How can get the current user name/id of the connected user in Sql
> Server 2005? I am using windows authentication. If I use USER or
> CURRENT_USER function it always returns DBO and I am looking for the
> network sign on which in my case would be URSC. Thanks.
>|||Try using SUSER_SNAME. See BOL for more info.
AMB
"S Chapman" wrote:

> How can get the current user name/id of the connected user in Sql
> Server 2005? I am using windows authentication. If I use USER or
> CURRENT_USER function it always returns DBO and I am looking for the
> network sign on which in my case would be URSC. Thanks.
>|||"S Chapman" <s_chapman47@.hotmail.co.uk> escribi en el mensaje
news:1150200242.086128.219900@.p79g2000cwp.googlegroups.com...
> How can get the current user name/id of the connected user in Sql
> Server 2005? I am using windows authentication. If I use USER or
> CURRENT_USER function it always returns DBO
If the user is admin, you will get dbo
Peter