Determining Users on Linked backend Database

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

Guest

I am working with a database linked to a "backend" database which is also
accessed by other users. Is there any method of determining which of these
users is currently accessing the backend database. The lbd viewer
applications apparenetly don't work on linked databases. The only method i am
aware of at the moment is the "brute force" approach of having each uiser
"log-in" to the backend when their application starts. My reason for needing
the information is to determine appropriate times to compact the backend
tables.
 
The LDB viewer application will work just fine on linked databases. But if
you're using it with the front end instead of the backend database, that is
the problem.
 
I was intending to use it from one of the front-end programs. if the user
calls the form stored on the back-end while in the front-end, will it
reference the front-end or the back-end?
 
Forms shouldn't be in the backend: they should be in the frontend.

In normal usage, you should have 2 separate lockfiles. There'll be one for
the frontend that'll always be open (in the same folder as the frontend, so
on the user's harddrive if you've done things the recommended way), and one
for the backend that should only be open while users are actually connecting
to the data.
 
So I'll return to my original question. How can a user on the front-end
determine who else is accessing the back-end tables?
 
prhood said:
So I'll return to my original question. How can a user on the front-end
determine who else is accessing the back-end tables?
Click to expand...


The LDBuser reoutines accept a path argument that specifies
which database to lookk at.

You can determine the path to a linked table in another MDB
by examining its Connect property.
path = Mid(CurrentDb.TableDefs!linkedtable.Connect, 11)
 
Back
Top