By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

Who is in the database?

P: n/a
I have a simple split database, and I want to know if it possible to
know if anyone is using the database? I don't want to do maintenance
on the back end if someone is using the front end.
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
> I have a simple split database, and I want to know if it possible to
know if anyone is using the database?
http://www.mvps.org/access/general/gen0034.htm
http://www.mvps.org/access/modules/mdl0055.htm
I don't want to do maintenance
on the back end if someone is using the front end...


.... because it is not possible from A2k onwards. ;-)

HTH - Peter

--
No mails please.
Nov 12 '05 #2

P: n/a
On 15 Sep 2003 08:35:56 -0700, bd*****@yahoo.com (Brian D'Souza)
wrote:
I have a simple split database, and I want to know if it possible to
know if anyone is using the database? I don't want to do maintenance
on the back end if someone is using the front end.


What you can do is just kick them off.

Use a startup form that checks for a value (MinsToMaint - or some
such) at some interval (5 seconds maybe).

If the value is greater than 0 then throw up a pop-up that displays a
polite message that the DB is going to maintenance mode. Give them
some time to finish up with what they were doing. Then close down the
FE.

Also, have the startup form check for value on open and shut down the
FE if > 0 (another polite message).

- Jim
Nov 12 '05 #3

P: n/a
On Mon, 15 Sep 2003 23:35:09 GMT, "Jim Allensworth"
<ji****@NOTdatacentricsolutions.com> wrote:
On 15 Sep 2003 08:35:56 -0700, bd*****@yahoo.com (Brian D'Souza)
wrote:
I have a simple split database, and I want to know if it possible to
know if anyone is using the database? I don't want to do maintenance
on the back end if someone is using the front end.


What you can do is just kick them off.

Use a startup form that checks for a value (MinsToMaint - or some
such) at some interval (5 seconds maybe).

If the value is greater than 0 then throw up a pop-up that displays a
polite message that the DB is going to maintenance mode. Give them
some time to finish up with what they were doing. Then close down the
FE.

Also, have the startup form check for value on open and shut down the
FE if > 0 (another polite message).

I should mention that the startup form is an always open form - it
need not be visible.
Nov 12 '05 #4

P: n/a
bd*****@yahoo.com (Brian D'Souza) wrote in message news:<26**************************@posting.google. com>...
I have a simple split database, and I want to know if it possible to
know if anyone is using the database? I don't want to do maintenance
on the back end if someone is using the front end.

Hmm... not possible from 2K onwards? See if KickEmOut at
www.datastrat.com does anything for ya...
Nov 12 '05 #5

P: n/a
> bd*****@yahoo.com (Brian D'Souza) wrote in message news:<26**************************@posting.google. com>...
I have a simple split database, and I want to know if it possible to
know if anyone is using the database? I don't want to do maintenance
on the back end if someone is using the front end.
Hmm... not possible from 2K onwards? See if KickEmOut at
www.datastrat.com does anything for ya...


Ok, not possible within standard Access.

Peter

--
No mails please.
Nov 12 '05 #6

P: n/a
Peter Doering <ne**@doering.org> wrote in message news:<bk************@ID-204768.news.uni-berlin.de>...
I have a simple split database, and I want to know if it possible to
know if anyone is using the database?


http://www.mvps.org/access/general/gen0034.htm
http://www.mvps.org/access/modules/mdl0055.htm
I don't want to do maintenance
on the back end if someone is using the front end...


... because it is not possible from A2k onwards. ;-)

HTH - Peter


I should have mentioned that I am working in Access 97.
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.