Access form not accepting values.

[usr123]

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 'Yes'.
I am looking for a solutions to figure out what's that i am missing?
ANy help is appreciated.

 

[rainman89]

Your query probably isn't update able.. better take a look at that first

 

[usr123]

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

 

[rainman89]

Did you design your query in access? If so, you can run the query and see if you can add a new entry to it.

 

[usr123]

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?

 

[rainman89]

Look on the very last row of the query results... do you see a *? if so its updatable.. if not.. you will need to adjust your query

 

[usr123]

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

 

[usr123]

ALso my database is sql,not access.

 

[missinglinq]

Allen Browne explains why some queries are Read-Only and suggest some workarounds:

http://allenbrowne.com/ser-61.html

 

[usr123]

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....

 

[usr123]

how could i make my query updatable?

 

[rainman89]

Without seeing your query and table structure, it is hard for us to tell.

I would start with a few tables and see if that query is updatable and add more tables and values seeing which one makes the query not updatable

 

[usr123]

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.

 

[usr123]

Also my query is a very simple select one.

 

[rainman89]

add the id field to the query.. that should allow you to update it

 

[usr123]

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

 

[usr123]

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?

 

[gemma-the-husky]

rainman is correct - you need a primary key in the table, methinks

note that you will be modifying the record data in the SQL database - how does the database normally get updated?

 

[usr123]

By adding ID filed to the table doesnt help either.It comes up with the error message 'Operations must use an updatable query'. Any ideas....

 

[usr123]

If i want to update an existing record then only i need an ID/Primary key in the table,but if i want to just enter the records then it shouldn't need any ID/Primary key. At the moment i only need to enter new records in the data and for that i dont need any updatable query.