Source to find users

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

Guest

Hello,

I was wondering if there is a way for me to add a button, link or something
that would tell me who is currentlt in the database. I maintain quite a few
and each time there is usually someone in it where I don't have exclusive
rights. My database is not split and is currently on the network drive. Any
help would be greatly appreciated!!

Thanks!!

Doug
 
Hi,


You should split your database, if possible, but that has nothing to do
with your actual problem.

KB article 285822 gives you an example, here somehow re-edited, to get
people that are connected to your db:

=======================================
Public Sub ShowUserRosterMultipleUsers()
'KB Q285822


Dim rs As New ADODB.Recordset


Set rs = CurrentProject.Connection.OpenSchema(adSchemaProviderSpecific,
_
, "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
Debug.Print rs.Fields(0).Name, "", rs.Fields(1).Name, "",
rs.Fields(2).Name, rs.Fields(3).Name

Do Until rs.EOF
Debug.Print rs.Fields(0), rs.Fields(1), rs.Fields(2), rs.Fields(3)
rs.MoveNext
Loop
End Sub
=======================================


Hoping it may help,
Vanderghast, Access MVP
 
Hi,

Where do I find KB article 285822? Also, if I split the database and send
each user a shortcut, will I have to re-distribute the shortcut everytime I
make and update to the back or front end of the database?

Thanks!!
 
Hi,


For the kb, it is at http://support.microsoft.com/kb/q285822

You can easily find the dedicated search engine at
http://support.microsoft.com/search/?adv=1 with Access as Search Product.


For a split (2 tiers) database, the data part is at one place (a workstation
for less that 10 connections, a "server" (with SERVER in the name of the OS)
for more). The front end part, forms and reports, is distributed on each and
every desktop having to use the connection. To split the database with a
minimum of problem, start the wizard to split the database on a second PC,
through the network, so that references to the data part will be remembered
through the full network name, rather than by C:\... Having the full
network reference to the data part, hard coded in the front end, it will
then a simple matter to "xcopy" the front end mdb file, on each and every
PC... So easy in fact, it may surprises you. And you can experiment with
dummy database! You will win speed, and thus, improve satisfaction of users,
and that won't hurt stability neither.



Hoping it may help,
Vanderghast, Access MVP
 
Excellent! The information is a great help. I will try and use it and see how
it turned out. Thank you very much for help!!

Doug
 
Back
Top