ASP Update on Access Datebase

[rp]

Not sure if this is an Access Issue or ASP but here goes

I have an asp script which does an which opens up a recordset against an
access table

I then do a .AddNew.
<insert the date into the record set>
then .Update

I do the update this way as I need to get the ID (AutoNumber) from what I've
updated using

CallID = rcSet("id")

This all works fine and the record gets added to the table. My problem is a
little further in the code I do a select on this table which should pick up
this inserted record but it doesn't find it. I know my SQL is ok as I can
manually run the sql against access and it picks up the row.

It seems like there a some kind of delay between actually doing a recordset
update and it being available to select?

Any help would be appreciated.

Thanks,

Rick

[Fadi El-Eter]

As I recall, to solve this problem, I used
Dim rec
set rec = server.createObject("ADODB.Recordset")
rec.open conn, sql, adopenkeyset, adlockoptimistic //I think you are opening
the recordset using adopendynamic.

If this doesn't work, you can always close the recordset and then get it
using a Select query.

--
Fadi El-Eter, itoctopus - http://www.itoctopus.com
"rp" <rpurse#hotmaildot.com> wrote in message
news:uI**************@TK2MSFTNGP11.phx.gbl...

Not sure if this is an Access Issue or ASP but here goes

I have an asp script which does an which opens up a recordset against an
access table

I then do a .AddNew.
<insert the date into the record set>
then .Update

I do the update this way as I need to get the ID (AutoNumber) from what I've updated using

CallID = rcSet("id")

This all works fine and the record gets added to the table. My problem is a little further in the code I do a select on this table which should pick up this inserted record but it doesn't find it. I know my SQL is ok as I can
manually run the sql against access and it picks up the row.

It seems like there a some kind of delay between actually doing a recordset update and it being available to select?

Any help would be appreciated.

Thanks,

Rick

[Bob Barrows [MVP]]

rp wrote:

Not sure if this is an Access Issue or ASP but here goes

I have an asp script which does an which opens up a recordset against
an access table

I then do a .AddNew.
<insert the date into the record set>
then .Update

I do the update this way as I need to get the ID (AutoNumber) from
what I've updated using

CallID = rcSet("id")

This all works fine and the record gets added to the table. My
problem is a little further in the code I do a select on this table
which should pick up this inserted record but it doesn't find it. I
know my SQL is ok as I can manually run the sql against access and it
picks up the row.

It seems like there a some kind of delay between actually doing a
recordset update and it being available to select?

Yes. Jet caches transactions to improve performance. See this article for a
way to force it to refresh the cache:
http://support.microsoft.com/?kbid=240317

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.