Re: Row Level Locking

No Dan, row level locking refers to a method of locking records so that two users can't attempt to change the same row at the same time. Access doesn't support row level locking, incidentally.

What you can use - and there's a few approaches - is a parameterised query. Check out 'parameter query' in Help.

In your case, the underlying query will no doubt include a field like 'ManagerID'. Set the criteria to a variable which you've obtained from the user validation process.

Cheers, Max %\

-- 
MAX HUGEN
Hugen Enterprises, 207 Flood St, Leichhardt NSW 2040, Australia
Email: maxhugen_at_ozemail.com.au              Tel: +612 9560 3061
....for world-class, custom business software......

Dan Slater wrote:


> 

> I'm developing a db to be accessed from the web.  It's been recommended to


> me to use Cold Fusion w/Access or SQL server.

> 

> However, the core requirements of this db is to allow a manager to log on

> and view/edit ONLY the employees that report to him/her (usually around 25

> employees per manager out of a 7500 record table).

> 

> Is "Row Level Locking" what I'm trying to do?

> 

> My experience with db's outside of Access is limited.  Can anyone help?

> 

> Dan Slater

> dslater2_at_cscmail.csc.com