Open Access table Exclusively

[Lxmm]

Hi all,

Is there a way to open an Access 2000-2003 table (not the database itself) exculsively so that only one user can modify records at a given point.

Thanks

 

[jebenson]

Check out this M$ article about transactions. It deals with isolation levels, which I believe is just what you are after.

Protecting Your Data Integrity with Transactions in ADO.NET

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[Lxmm]

Many thanks for the info.