Determine who is connected

[ABM]

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?

 

[Roger Carlson]

1. If the user does not have Create rights to the DIRECTORY where the
database resides, no LDB file will be created. Check network rights. All
users should have Read, Update, Delete, and Create rights to the directory.

2. I don't know, sorry.
--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Ken Snell [MVP]]

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?

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.