REPOST: Unique connection ID not name.

Hello,

When an Access program connects to a database, is there a unique connection
id? I've used the User Roster to check connections, but just wondering if
there was two machines with the same name, it would throw things off
somewhat.

Any help would be great.

Thanks!

re: REPOST: Unique connection ID not name.

If there are 2 machines with the same name, that will throw your whole
network off...

"Jozef" <SPAM_O_NATOR@telus.net> wrote in message
news:UNqTe.411997$5V4.263387@pd7tw3no...[color=blue]
> Hello,
>
> When an Access program connects to a database, is there a unique[/color]
connection[color=blue]
> id? I've used the User Roster to check connections, but just wondering if
> there was two machines with the same name, it would throw things off
> somewhat.
>
> Any help would be great.
>
> Thanks!
>
>
>[/color]

re: REPOST: Unique connection ID not name.

That's why I'm asking if there's a unique connection ID. ;)

"MacDermott" <macdermott@nospam.com> wrote in message
news:t1rTe.8590$FW1.5622@newsread3.news.atl.earthl ink.net...[color=blue]
> If there are 2 machines with the same name, that will throw your whole
> network off...
>
> "Jozef" <SPAM_O_NATOR@telus.net> wrote in message
> news:UNqTe.411997$5V4.263387@pd7tw3no...[color=green]
>> Hello,
>>
>> When an Access program connects to a database, is there a unique[/color]
> connection[color=green]
>> id? I've used the User Roster to check connections, but just wondering
>> if
>> there was two machines with the same name, it would throw things off
>> somewhat.
>>
>> Any help would be great.
>>
>> Thanks!
>>
>>
>>[/color]
>
>[/color]

re: REPOST: Unique connection ID not name.

Oops, sorry, I see what you mean now. It will only throw your network off
if you are using NetBui. All network protocols are TCP/IP and all static.


"MacDermott" <macdermott@nospam.com> wrote in message
news:t1rTe.8590$FW1.5622@newsread3.news.atl.earthl ink.net...[color=blue]
> If there are 2 machines with the same name, that will throw your whole
> network off...
>
> "Jozef" <SPAM_O_NATOR@telus.net> wrote in message
> news:UNqTe.411997$5V4.263387@pd7tw3no...[color=green]
>> Hello,
>>
>> When an Access program connects to a database, is there a unique[/color]
> connection[color=green]
>> id? I've used the User Roster to check connections, but just wondering
>> if
>> there was two machines with the same name, it would throw things off
>> somewhat.
>>
>> Any help would be great.
>>
>> Thanks!
>>
>>
>>[/color]
>
>[/color]

re: REPOST: Unique connection ID not name.

Well, this is getting pretty far off Access, but we have a network which is
all WinXP, where NetBui isn't even natively installed, and it gets upset if
we add a machine with the same name as an existing one...
The main point of my post is to say that I don't think it's something
that should be addressed at the Access level.


"Jozef" <SPAM_O_NATOR@telus.net> wrote in message
news:axrTe.122445$Hk.72772@pd7tw1no...[color=blue]
> Oops, sorry, I see what you mean now. It will only throw your network[/color]
off[color=blue]
> if you are using NetBui. All network protocols are TCP/IP and all static.
>
>
> "MacDermott" <macdermott@nospam.com> wrote in message
> news:t1rTe.8590$FW1.5622@newsread3.news.atl.earthl ink.net...[color=green]
> > If there are 2 machines with the same name, that will throw your whole
> > network off...
> >
> > "Jozef" <SPAM_O_NATOR@telus.net> wrote in message
> > news:UNqTe.411997$5V4.263387@pd7tw3no...[color=darkred]
> >> Hello,
> >>
> >> When an Access program connects to a database, is there a unique[/color]
> > connection[color=darkred]
> >> id? I've used the User Roster to check connections, but just wondering
> >> if
> >> there was two machines with the same name, it would throw things off
> >> somewhat.
> >>
> >> Any help would be great.
> >>
> >> Thanks!
> >>
> >>
> >>[/color]
> >
> >[/color]
>
>[/color]

re: REPOST: Unique connection ID not name.

"Jozef" <SPAM_O_NATOR@telus.net> wrote in
news:UNqTe.411997$5V4.263387@pd7tw3no:
[color=blue]
> When an Access program connects to a database, is there a unique
> connection id? I've used the User Roster to check connections,
> but just wondering if there was two machines with the same name,
> it would throw things off somewhat.[/color]

What kind of database? Jet? SQL Server? Something else?

What kind of connection? DAO? ADO? ODBC?

The answers to your question may depend on the answers to this
question, as well as to the techniques used in a specific connection
method (e.g., are you re-using a single connection or creating new
connections?).

Basically, your question is too vague to ba answerable unless the
person answer just happens to make exactly the right assumptions
about the context in which you're asking your question.

It might be better to describe the problem you're having that
prompts the question in the first place, rather than boiling the
question down to something so abstract that it can't really be
answered.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

re: REPOST: Unique connection ID not name.

Connecting to an Access database using the User Roster, which is I belive
the only way to view connections to the database from within Access or VB.
Either way, is there ANY way to connect to access and poll all the
connections to determine a unique id?

No big deal, I will probably just roll the dice and use the User Roster. If
you do know of any way to extract a unique connection id from a database
connection (PID maybe?) I'd love to hear it.

Thanks!


"David W. Fenton" <dXXXfenton@bway.net.invalid> wrote in message
news:Xns96CAA3078221Bdfentonbwaynetinvali@216.196. 97.142...[color=blue]
> "Jozef" <SPAM_O_NATOR@telus.net> wrote in
> news:UNqTe.411997$5V4.263387@pd7tw3no:
>[color=green]
>> When an Access program connects to a database, is there a unique
>> connection id? I've used the User Roster to check connections,
>> but just wondering if there was two machines with the same name,
>> it would throw things off somewhat.[/color]
>
> What kind of database? Jet? SQL Server? Something else?
>
> What kind of connection? DAO? ADO? ODBC?
>
> The answers to your question may depend on the answers to this
> question, as well as to the techniques used in a specific connection
> method (e.g., are you re-using a single connection or creating new
> connections?).
>
> Basically, your question is too vague to ba answerable unless the
> person answer just happens to make exactly the right assumptions
> about the context in which you're asking your question.
>
> It might be better to describe the problem you're having that
> prompts the question in the first place, rather than boiling the
> question down to something so abstract that it can't really be
> answered.
>
> --
> David W. Fenton http://www.bway.net/~dfenton
> dfenton at bway dot net http://www.bway.net/~dfassoc[/color]

re: REPOST: Unique connection ID not name.

"Jozef" <me@you.com> wrote in news:prqUe.164016$Hk.121675@pd7tw1no:
[color=blue]
> Connecting to an Access database using the User Roster, which is I
> belive the only way to view connections to the database from
> within Access or VB. . . .[/color]

No, it's not the only way to do it. It's the most convenient, but
it's an ADO feature, and before ADO existed in Access, we had the
LDBUSR.DLL for figuring out who was connected.
[color=blue]
> . . . Either way, is there ANY way to connect to
> access and poll all the connections to determine a unique id?[/color]

Not so far as I know. I haven't looked at this for a long time, but
if I remember correctly you only get machine name and username, and
one listing for that from each connection each user has open.

Now, perhaps workstation+domain logon name is sufficient for your
purposes, but I believe that's all you're ever going to get.
[color=blue]
> No big deal, I will probably just roll the dice and use the User
> Roster. If you do know of any way to extract a unique connection
> id from a database connection (PID maybe?) I'd love to hear it.[/color]

I don't know that Jet records such a thing in the LDB file, and I
know that I've never encountered any interface for getting such
information out of an LDB, so if the information does exist, so far
as I know, there's no interface defined for it.

The only alternative would be binary examination of the LDB file to
see what you can learn from that, but I'm not interested in that
kind of thing.

Why do you need more information than workstation+username?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

re: REPOST: Unique connection ID not name.

Hi David,

Thanks. I think I'll likely fly with just the user name and machine name.
The reason I wanted to look at unique connections is that I'd like ot be
able to log connections to the database, and mark when those connections
were terminated. If a user has two or three connections to the database, it
would be the same user name and machine name, so if I cleared the connection
when one instance of the database was shut down, it would clear all the
connections (even though others would still be connected) unless I could
determine a unique connection id somehow. I can come up with a work around,
I was just hoping there was a cleaner, easier way.

Thanks again!

"David W. Fenton" <dXXXfenton@bway.net.invalid> wrote in message
news:Xns96CDCA04C9F96dfentonbwaynetinvali@216.196. 97.142...[color=blue]
> "Jozef" <me@you.com> wrote in news:prqUe.164016$Hk.121675@pd7tw1no:
>[color=green]
>> Connecting to an Access database using the User Roster, which is I
>> belive the only way to view connections to the database from
>> within Access or VB. . . .[/color]
>
> No, it's not the only way to do it. It's the most convenient, but
> it's an ADO feature, and before ADO existed in Access, we had the
> LDBUSR.DLL for figuring out who was connected.
>[color=green]
>> . . . Either way, is there ANY way to connect to
>> access and poll all the connections to determine a unique id?[/color]
>
> Not so far as I know. I haven't looked at this for a long time, but
> if I remember correctly you only get machine name and username, and
> one listing for that from each connection each user has open.
>
> Now, perhaps workstation+domain logon name is sufficient for your
> purposes, but I believe that's all you're ever going to get.
>[color=green]
>> No big deal, I will probably just roll the dice and use the User
>> Roster. If you do know of any way to extract a unique connection
>> id from a database connection (PID maybe?) I'd love to hear it.[/color]
>
> I don't know that Jet records such a thing in the LDB file, and I
> know that I've never encountered any interface for getting such
> information out of an LDB, so if the information does exist, so far
> as I know, there's no interface defined for it.
>
> The only alternative would be binary examination of the LDB file to
> see what you can learn from that, but I'm not interested in that
> kind of thing.
>
> Why do you need more information than workstation+username?
>
> --
> David W. Fenton http://www.bway.net/~dfenton
> dfenton at bway dot net http://www.bway.net/~dfassoc[/color]