oledb + access refresh problem

[Vipper]

Hi,

I'm using ACCESS + oledb with ado.net 2 and I'm having this behaviour when I
execute the next sequence:

1. INSERT INTO customer ...
2. SELECT * FROM customer (I execute it inmediately)

But the change of step 1 doesn't refresh in step 2, . However if I execute
step 2 again after 1 or 2 seconds, the change refresh correctly.

Any ideas?

 

[Mary Chipman [MSFT]]

My guess is the SELECT, which only requires a shared lock, was
executed before the INSERT, which requires an exclusive lock. You can
get a better idea of what might have happened by sticking a Profiler
trace on the call.

--Mary