Update MS Access record doesn't work right

[Tsengtan]

I use the DW server behavior "Update Record" to update my MS Access record.
The Server behavior not only update the very record, it also replace its
privious or next record. Does anyone out there know what went wrong? Your
earliest attention will be much appreciated.

[danilocelic *TMM*]

Tsengtan wrote:

> I use the DW server behavior "Update Record" to update my MS Access record.
> The Server behavior not only update the very record, it also replace its
> privious or next record. Does anyone out there know what went wrong? Your
> earliest attention will be much appreciated.

I've not seen such an issue before. Have you modified any of the UPDATE
code? the only time I'd think that the code could update more than one
record is if you're telling it to perform the update based upon a field
that is not a unique identifier for the row.

I'd suggest that you ask your question over in the Application
Development forum and post the code you're using. Also, give detailed
steps for getting the page to do what you're aking about such as enter x
in text field y etc. You will likely also need to post a copy of the
table, including the data types and some sample values for your table.




Danilo

[twocans]

how have u set the primary key in your database, have you set it to number
or auto number.

regards

kenny



"Tsengtan" <webforumsuser@macromedia.com> wrote in message
news:damnpf$7hj$1@forums.macromedia.com...

>I use the DW server behavior "Update Record" to update my MS Access record.
> The Server behavior not only update the very record, it also replace its
> privious or next record. Does anyone out there know what went wrong? Your
> earliest attention will be much appreciated.
>