REPOST: Unique connection ID not name.

[Jozef]

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!

[MacDermott]

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

"Jozef" <SP**********@telus.net> wrote in message
news:UNqTe.411997$5V4.263387@pd7tw3no...

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!

[Jozef]

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

"MacDermott" <ma********@nospam.com> wrote in message
news:t1*****************@newsread3.news.atl.earthl ink.net...

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

"Jozef" <SP**********@telus.net> wrote in message
news:UNqTe.411997$5V4.263387@pd7tw3no...

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!

[Jozef]

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" <ma********@nospam.com> wrote in message
news:t1*****************@newsread3.news.atl.earthl ink.net...

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

"Jozef" <SP**********@telus.net> wrote in message
news:UNqTe.411997$5V4.263387@pd7tw3no...

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!

[MacDermott]

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" <SP**********@telus.net> wrote in message
news:axrTe.122445$Hk.72772@pd7tw1no...

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" <ma********@nospam.com> wrote in message
news:t1*****************@newsread3.news.atl.earthl ink.net...

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

"Jozef" <SP**********@telus.net> wrote in message
news:UNqTe.411997$5V4.263387@pd7tw3no...

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!

[David W. Fenton]

"Jozef" <SP**********@telus.net> wrote in
news:UNqTe.411997$5V4.263387@pd7tw3no:

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.

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

[Jozef]

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" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@216.196. 97.142...

"Jozef" <SP**********@telus.net> wrote in
news:UNqTe.411997$5V4.263387@pd7tw3no:

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.

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

[David W. Fenton]

"Jozef" <[e-mail]> wrote in news:prqUe.164016$Hk.121675@pd7tw1no:

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. . . .
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.
. . . Either way, is there ANY way to connect to
access and poll all the connections to determine a unique id?
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.
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.

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

[Jozef]

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" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@216.196. 97.142...

"Jozef" <[e-mail]> wrote in news:prqUe.164016$Hk.121675@pd7tw1no:

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. . . .

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.

. . . Either way, is there ANY way to connect to
access and poll all the connections to determine a unique id?

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.

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.

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