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

EditMode Property Help

P: n/a
Hello,

I have my Database setup with a backend and several instances of the
same form in a frontend linked to the backend tables. Their are
several of these frontend stations. What I like to do is when a user
is working with a record another user on another station wont be able
to enter into that record for editing. I would like a message box to
appear telling the user to try again at another time. I was told
about EditMode Property function, but i'm a little clueless on how to
use it. I don't even know if this is the right way to go. Any help
with this would be great.

David Ehrenreich
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You'd have to set the "Default record locking" option on the:

Menu bar Tools > Options > Advanced tab

to "Edited record."

- From the Access Help article "Set options for a shared Access
database":

"This setting takes effect the next time you open the Access database,
but you must use the Open command on the File menu rather than the
list of most recently used files at the end of the File menu."

Set the same property (a ComboBox) in a Query's (Design View) Property
dialog box.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQAckNYechKqOuFEgEQLbawCgr2rMwJZGm9wEI6IoMd7Qpn H1GAMAoPry
/USzqF2ibfYTCRZwxnm+Bek3
=CYro
-----END PGP SIGNATURE-----
David Ehrenreich wrote:
Hello,

I have my Database setup with a backend and several instances of the
same form in a frontend linked to the backend tables. Their are
several of these frontend stations. What I like to do is when a user
is working with a record another user on another station wont be able
to enter into that record for editing. I would like a message box to
appear telling the user to try again at another time. I was told
about EditMode Property function, but i'm a little clueless on how to
use it. I don't even know if this is the right way to go. Any help
with this would be great.

David Ehrenreich


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.