> Requirement: Using Firebird from Access.
> Windows users.
>
> Yes you are right I come from a SQL Server background.
> I have never used an MGA - therefore the strange questions.
> I might be wrong but in SQL Server you can have multiple read locks on a record but read locks block write locks and vice versa. Also you can only have one write lock. I don't think SQL Server got MGA features.

SQL Server got something similar in V2005, but it has to be enabled per
database AFAIR.

Firebird MGAs is pretty much: "writers don't block readers and vice versa".


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!