Updating Data in Access? When Does it happen?

[Verbetex]

I've got some ASP/ADO code which inserts the data submitted by the form into an Access Database.

This works fine, and the data goes in, however, if I try to query the database in the same ASP file, the data does not exist yet.

Is this because the ASP is executing faster than the database updates and so the data does not exist just yet?

Thanks

 

[palbano]

> Is this because the ASP is executing faster than the
>> database updates and so the data does not exist just yet?

no -There are only 10 types of people in the world, those who understand binary and those who don't-

-pete

 

[browolf]

are u creating a new recordset after the update? ===============
Security Forums

http://www.security-forums.com

 

[Verbetex]

sure am.

I have one that I use to execute the INSERT SQL statement, then another which queries that data, but it's not found until the page has loaded and the query is run again from another page.

 

[palbano]

>> Is this because the ASP is executing faster than the
>> database updates and so the data does not exist just yet?

i want to change my orginal answer to "maybe" LOL -There are only 10 types of people in the world, those who understand binary and those who don't-

-pete

 

[baddos]

Post the code.