count ADODB.Connections

[mohanvijay]

Hai all,

Is there anyway to count or find that how many ADODB.Connections currently used particular Access(mdb) database (without using Access 11.0 library)

Please help

[hansup]

I'm not aware of any such method. You might need to keep track of those connections as you create and destroy them.

You might also inspect the .LDB lock file, but I doubt it records more than a single entry for each connected user/machine combination.

Why do you want that information, and how do you intend to use it? Assuming your interest is more than idle curiosity, give us details about what you want to accomplish and maybe someone can offer you a solution.

[mohanvijay]

Hai hansub,
thanks for your reply

I just want to know that if before the machine connect to the database check the already any other machine accessing the same database

I don't like to use create seperate table for users in the database and i think ther must be another way to count the ADODB.Connections

[HiTechCoach]

The .LDB/.LCCDB lock file does have a list of connected users.

[mohanvijay]

Hai HitechCoach

thanks for your reply

i connect one mdb file with two coonections and open the ldb file in notepad that shows like below
"䥖䅊䅙啋䅍R††††††††††摁業n†††††††††††††䥖䅊䅙啋䅍R††††††††††摁業n†††††††††††††"

in above text "摁業n" repeats two times which means two connections (i think)
is this a way to identify connections? or how to i read .ldb file

please help me out

[HiTechCoach]

Here is what I use to read the LDB file:

Who's Logged On / Who's Connected (v1.6.1) (http://www.utteraccess.com/forum/Who-s-Logged-Who-s-Con-t1897146.html&hl=connected)

[mohanvijay]

Thanks for the link HitechCoach

[HiTechCoach]

You're welcome.

Glad we could assist.

[Tabitha30]

You said very professional,I will remember