if i update a record in access db how can i update a date?
i set it as "ms access date" in update but im getting error.
can i set access to update date automatically if record was changed?

Hi,

Can't you just have a seperate field within the DB called date?

When a page is updated or inserted you could also update/insert (as applicable) when the DB is changed.

www.k.abbott.btinternet.co.uk/

i do, but i cant update it, i get a error message, i thing is date format.

In your recordset that you use to update the record with, try just selecting the columns that you are updating (not the All radio button the Selected radio button).

www.k.abbott.btinternet.co.uk/