Access and locking

[marnitzg]

Couple of questions:

1. What locking method does MS Access use?
2. What errors (if any) are produced when a locked record is read/edited
3. Does Access have a maximum number of connections. If so, how many?

Thanks for any response

[Beacon]

1) Depending on what connection your using!
2) read none. Edited it's locked it cant be.
3) 255

b

[marnitzg]

Thanks. Just a follow up.

What locking methods does access use / the different connections.
"Edited it's locked it can't be". Umm, it can't be edited? So does it stack the transactions or does it throw an error?

[Beacon]

Error usually!
No transaction stacking i most cases.