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

[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

[Bob Barrows [MVP]]

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

sirinath wrote:

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.
>

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

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"