Problems using Access

[ucx]

Hello everyone,

I'm with trouble using access DB..

When i do a INSERT instruction and a time later a SELECT instruction, if this time was lower than a couple of seconds, the SELECT instruction cannot bring information resulted from INSERT instruction..
I think the database is executing the both instructions at the same time..

Can you help me?

Thank you!

 

[rcombs4]

Can we see some code that might help us troubleshoot?

 

[ucx]

Can we see some code that might help us troubleshoot?

hi!
nothing special in that code..
its just...

select -> returns 10 values
insert -> add one registry
select -> should return 11 values, but returns only the 10 values..

but, if i wait...

and do a select again
select -> here it is! 11 values!

but.... my application can't sit down, drink some coffe and wait for the time i think it be necessary to ACCESS do the INSERT request... but it can't do the both requests at the same time as well...

i dont know what to do... i've never had this problem in any other programming language..

thanks for attention.. and forgive my gramatic errors, i speak portuguese.

 

[Tom]

As mentioned above, you really need to post your code in order for anyone to give more detailed help. Your pseudo code isnt going to point out any possible errors...