Access Help

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

Guest

How can I set this program up to advise me of who is in a particular file
that I wish to open? In Excel it is set up to let one know who is in a
particular workbook prior to asking if you would like to open the file as
read only. Can Access be set up to do the same???
 
Hi, Tanya.
In Excel it is set up to let one know who is in a
particular workbook prior to asking if you would like to open the file as
read only. Can Access be set up to do the same???
Click to expand...

No. This is not an issue in a properly designed database. Access is able
to handle a multiuser environment, whereas Excel is not. Excel needs to
lock the entire workbook when other users need to look at it to prevent
multiple users from altering the same data, which compromises data
integrity. Other users who are adding/changing/deleting records in an
Access database have the affected records locked until the operation is
finished, allowing the next user to alter each record as soon as it is
unlocked.

You did properly design your database for a multiuser environment, didn't
you? You have a split database with the back end (with tables and
relationships) located on a network shared directory and a copy of the front
end (with forms, queries, modules, et cetera) on each user's workstation?
If not, then please see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

If you just want to know who has the back end of the database file open,
then you'll either need to use the LDB Viewer tool or you'll need to write
some VBA code in your application that provides this feature. You may find
a link to this tool and other free diagnostic tools in the "Free Microsoft
Access Troubleshooting Tools" section on this Web page:

http://www.Access.QBuilt.com/html/links.html

Sample code for viewing all users logged into an Access 2002 or 2003
database is available on this Web page (with a link to the Access 2000
version):

http://support.microsoft.com/default.aspx?id=285822

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top