By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,053 Members | 1,595 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,053 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Oct 9 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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"
Oct 9 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.