Is there a way to find the number of records locked by a transaction?

[prabhafriend]

No ways to find the count of records locked?

http://accessworld.accessworld.netdna-cdn.com/forums/images/misc/progress.gif

[prabhafriend]

Please respond. I need to expand the MaxLocksperfile respectively

[orange]

Please see

http://support.microsoft.com/default.aspx?scid=kb;en-us;286153

[prabhafriend]

Orange. Thanks for your reply. But I already know how to set the MaxLocksperfile through registry or temporarily using the setoption method. My primary question is "Is there any way that we can know how many page locks has been placed by a transaction?" Anyway another rises in me. Why they are called page locks instead of recordlocks? What is a page in respect of database? Kindly help. I need to understand what is happening inside.
Note:
Currently I'm expanding the MaxLocksperfile through the setoption by counting number of records that transaction is going to perform before commiting it. Will this method solve this issue?

[orange]

Locking is discussed at this site, but no iinfo on finding out how many records are locked.

http://msdn.microsoft.com/en-us/library/aa189633%28v=office.10%29.aspx

The previous link I gave said default locks is 9500. It also showed how to set the locks to 200000 in code.

There is interesting reading here, but no final solution,
http://www.access-programmers.co.uk/forums/showthread.php?t=206824&highlight=record+locking