i have the wierdest problem

i have an asp page which contains several hidden fields with values
these hidden fields are inserted in an access database with an on bodyload

now most of the times the record gets inserted correctly, but on some occasions
the record gets inserted 2 or 3 times....... now in my book this is completely
impossible but it happens for some reason...

did anyone experienced something like this??? and what could be the problem

hope you can help

greetzzz Sander

This is indeed very strange and also in theory impossible.... are you maybe calling a insert recordset behaviour more than once or that you have twice an action a button?!

<hr><b>DMXZone support manager</b><br><a href="www.kousman.nl">Kousman web resellers</a>

nope none of the above and it happens occasionally

ive heard of this in the past on access, and from what i can remeber it's down to a corrupted table in access.

try doing a compact and repair after inserts, and see if that helps. it will reduce the size and remove all cache and temporary info from the db.

regards

Dave Thomas
<b>DMX Zone Manager</b>

I think this has a thing to do with security

I can update records on localhost... but not on the server when i upload it....

This is most probably a security issue...

Is there a simple solution...

Please help
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
ive heard of this in the past on access, and from what i can remeber it's down to a corrupted table in access.

try doing a compact and repair after inserts, and see if that helps. it will reduce the size and remove all cache and temporary info from the db.

regards

Dave Thomas
<b>DMX Zone Manager</b>

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> <pre id=code><font face=courier size=2 id=code> </font id=code></pre id=code> <pre id=code><font face=courier size=2 id=code> </font id=code></pre id=code> <pre id=code><font face=courier size=2 id=code> </font id=code></pre id=code> <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote> <pre id=code><font face=courier size=2 id=code> </font id=code></pre id=code><font face='Andale Mono'></font id='Andale Mono'><font face='Script MT Bold'></font id='Script MT Bold'>

milindsmartie