Access 2003

[MazenMrad]

Hi every one.
i`m using an access database (2003) i can select (view) data but i have a probleme with insert or update a record.
there is no error the insert or update queries returns 1 but no modifications in the database.
can anyone help?

[usslindstrom]

If you're trying to update a record - you won't be able to do it with just a normal "select" query. "select" queries (the kind you make when you use the normal access wizard) are only read-only of the data in the tables.

You have to make an "update" query to be able to edit a table via queries:

http://office.microsoft.com/en-us/ac...765271033.aspx

(it looks like they wrote that for Office 2007, but it should be the same steps in 2k3 for ya).