Search results

could it be the case of database permissions? If i haven't got the permissions to add in the database then i wouldnt be able to add new record. How would i fix it then?

what difference does it make? Coz fileds at the moment are accepting int/number value.

Also my query is a very simple select one.

i have got only one table, and i m selecting only 2 fields from tht table on the form. I want these fields to be empty when i open the form so that user could enter the data.

how could i make my query updatable?

Thanks for the link.I have checked that already and doesnt seem like one of the stated reasons. I think it has got something to do with thedatabase permissions....

ALso my database is sql,not access.

Its not updatable. I m looking into how i can make it updatable now.Thanks for guiding me.

Yes i designed it in access through query builder. I can run it where it gives me the records i am selecting.i m looking into how can i update it?

How can i check that whether my query is updatable or not?

Hello, I am new to access. I have designed a little form, attached to sql database. When i open the form in form view, it shows the last record value of the fields but doesnt allow me to enter new values in the form. Form's recordset is set to the query,data entry is 'Yes', allow aditions is...