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
Printable View
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
1) Depending on what connection your using!
2) read none. Edited it's locked it cant be.
3) 255
b :)
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?
Error usually!
No transaction stacking i most cases.