Hi, I use AccessXP with ADO to open record in SQL Server. I set Mode property of connection object to adModeShareExclusive before connection object is opened. Before connection object is closed, I open another program to read the same record. Result is It can read.
I think the correct is It should not able to read, shouldn't it ? How to set to open exclusively ?