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

record-locking?

P: n/a
Does any version of Access offer record-locking? By this I mean the
capability to restrict write-access to a particular record.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Kevin" wrote
Does any version of Access offer
record-locking? By this I mean the
capability to restrict write-access
to a particular record.


Yes, Access 2000 and later versions offer this capability, but it must be
set up specifically for the tables -- it is not the default. My personal
caution is to be certain you have applied all the Service Packs for your
version of Access and all the Service Packs for the Jet database engine.

Some have noted, also, that they believe each record will occupy a "page",
the size used in page-level locking.

Larry Linson
Microsoft Office MVP
Nov 13 '05 #2

P: n/a
Kevin,
Could you explain what *you* mean by record-locking with an example?
Don't take that the wrong way, but in Access that has a *very* specific
meaning, and I wanted to know if that was what you intended.
My interpretation of your question is this:
Can I restrict which user may edit *specific* records. If that's the
case, then you'd have to lock the users out of the query interface,
because they can change any of the data in the returned recordset if
the query is updateable.

I'll wait for a response before I either (a) muddy the waters further;
(b) make a complete fool of myself (too late!), (c) say something that
is patently untrue...

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.