OleDB and Access Problem in C# (.NET Framework 2.0)

  • Thread starter Thread starter sirinath
  • Start date Start date
S

sirinath

Hi,

Is there a known issue in using Access through OleDB provider in C#
(.NET Framework 2.0) where inserted records are not reflected in
subsequent queries. Worst still, if the PK is a auto number an
exception is thrown.

Please be good enough to point me to some resources on resolving this
error. Please be good enough to reply. If anybody else has faced this
same problem let me know.

Thanks in advance!

Best regards, Suminda Sirinath Salpitikorala Dharmasena
 
sirinath said:
Hi,

Is there a known issue in using Access through OleDB provider in C#
(.NET Framework 2.0) where inserted records are not reflected in
subsequent queries. Worst still, if the PK is a auto number an
exception is thrown.

Please be good enough to point me to some resources on resolving this
error. Please be good enough to reply. If anybody else has faced this
same problem let me know.
Click to expand...
Please remove the non-dotnet groups from your dotnet crossposts in the
future.

That said, I wonder if you are running into the Jet delayed-write behavior.
I've not heard that this is an issue in ado.net, but on reflection, I see no
reason for its not being an issue:
single connection:
http://support.microsoft.com/?kbid=240317

two connections:
http://support.microsoft.com/kb/200300
 
Back
Top