Determining Users on Linked backend Database

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.
 
P

Paul Overway

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.
 
G

Guest

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?
 
D

Douglas J. Steele

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.
 
G

Guest

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?
 
M

Marshall Barton

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?


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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top