Re: ASP & ADO

Hi,

It could be in a case if same ASP page called right after you inserted the
data. I do not see any other reason why it would happen.

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"DNKMCA" <dnk@xxxxxxx> wrote in message
news:Or2G8kmjFHA.232@xxxxxxxxxxxxxxxxxxxxxxx
> ASP & ADO
>
> I have a msaccess database with following fields & datatype
>
> ID AutoNumber
> Name Text(100)
> PWD OLE Data -- This is to Protect password field.
>
> im using two routines ( in ASP)
>
> 1) to find the name exists --
> 2) add new user -- using INSERT INTO to input data into
> table
>
> :::sample code:::
>
> if userfound(xyz)=no
> 'open ado connection
> ' insert data
> else
> 'show error [User Found]
> end if
>
> Problem:
> When i execute the code, new user is getting added into table,
> simultaneously [user found] error popping up.
> how to control this.
>
>
> Thanks
>
>


.