Copy Back End while Front End in use

[Guest]

I am using Office 2003 on Windows XP.

Q1)
Would it be considered "safe" to copy a Back-End DB to a development area,
even though users are currently active in the Front-End?

Q2)
Is it possible using VBA to determine if any users are currently in any of
the Front-End DBs? If so, how? Could example VBA be posted?

Thanks much for your assistance.

 

[Douglas J. Steele]

1) Check whether the locking file (.ldb) exists or not. If it doesn't, you
should be okay to copy.

2) You mean you've got 5 users, each with their own front-end, and you want
to somehow know who they are? Check
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp#_Toc493299690
(I believe this will only work, though, while they're actually connected to
the back-end. In other words, if there is no locking file, you won't know
that they've got the front-end open, but just aren't connected at the
moment)

 

[Roger Carlson]

1) I wouldn't recommend it. That is to say, I don't know, but MDB files can
be easily corrupted, so I wouldn't chance it.

2) Take a look here, for a number of options:
http://www.mvps.org/access/general/gen0034.htm

Also, if you just want to kick all the users out of all of the front-ends,
on my website (www.rogersaccesslibrary.com), is a small Access database
sample called "LogUsersOff.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
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