No subject


Wed Dec 28 11:38:03 CST 2011


the Access 2000 Developer’s Handbook Volume 2, I
gather that the answer is that record locking is a
function of the database. So since an ADP bypasses Jet
and goes straight through SQL Server OLE DB then it is
true record level locking when accessing the data
through a form within an ADP. So record locking when
accessing data within a MDB via another MDB is page
locking because of Jet (although I know Access 2000
and greater does allow for record locking if told to).


****Quick question on this then, if an MDB use linked
ODBC tables to access data within a SQL database is
page locking employed because it passes through Jet?

I think my confusion on record locking employed when
using an ADP was actually a result of what I was
reading in the Access 2000 Developer’s Handbook Volume
2. It covers a great deal of Client Server development
using MS Access in chapter 3. But what it doesn’t seem
to mention much about in the client server chapter is
ADP’s and how they differ from an MDB (there is some
there but not a lot). Later in the book it provides a
lot of information on ADP’s but it never really comes
out and says some of what I was looking for. It does
come out and say Optimistic locking but I didn’t get a
clear picture that it was saying true record locking.
I guess I was reading too much into it. 

If I’m mistaken please let me know but a bound form
within an ADP to a SQL2000 database will employ true
Optimistic record locking only on the current record.
So in a data entry only environment (where no one
works on the same records) there should not be much in
the manner of record locking?

To everyone who took the time to comment on this I
appreciate your assistance immensely. Thank you very
much.

Bob


__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com



More information about the AccessD mailing list