Determine who is connected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the following to populate a list box to display who is connected
to the database. The frontend is on the users machine and the data is linked
on a network drive. My questions are


Dim cn As New ADODB.Connection
Dim rcd As New ADODB.Recordset

cn.Provider = "Microsoft.Jet.OLEDB.4.0"
cn.Open "Data Source=Q:\Network\myData.mdb"

Set rcd = cn.OpenSchema(adSchemaProviderSpecific, ,
"{947bb102-5d43-11d1-bdbf-00c04fb92675}")

1. This will work if Access creates an ldb file on the network when the
user starts the front end database. On one database no ldb file is created
on the network and I can't figure out why.

2. Why does my name appear when I am not connected to the database?
 
ABM said:
I am using the following to populate a list box to display who is connected
to the database. The frontend is on the users machine and the data is
linked
on a network drive. My questions are


Dim cn As New ADODB.Connection
Dim rcd As New ADODB.Recordset

cn.Provider = "Microsoft.Jet.OLEDB.4.0"
cn.Open "Data Source=Q:\Network\myData.mdb"

Set rcd = cn.OpenSchema(adSchemaProviderSpecific, ,
"{947bb102-5d43-11d1-bdbf-00c04fb92675}")

1. This will work if Access creates an ldb file on the network when the
user starts the front end database. On one database no ldb file is
created
on the network and I can't figure out why.

2. Why does my name appear when I am not connected to the database?
Click to expand...

Answer to #2: you are connected to the database.... this occurs during the
code that you run because the database must connect in order to deterrmine
who is connected, and thus you are connected.
 
Back
Top