I cannot enter data into a query in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a query linked to a number of tables. The query has fields
which are the links to the other tables. In some records, not all, i want
somes field to be blank so have used the IsNull function to allow this, but
when i have done this it seems to lock the query and i am unable to enter any
data into the query. Any suggestions, if you need any more if please let me
know

Thanks
 
All tables should be linked from primary key fields to foreign key fields.

I don't have a clue how you are using the IsNull function to allow
something. Perhaps you should reply with your SQL view as well as define
which are primary and foreign key fields.
 
in message
I have set up a query linked to a number of tables. The query has fields
which are the links to the other tables. In some records, not all, i want
somes field to be blank so have used the IsNull function to allow this, but
when i have done this it seems to lock the query and i am unable to enter any
data into the query. Any suggestions, if you need any more if please let me
know

Thanks
Click to expand...


Tim Halpin (BV),

Although meant for an sqlserver newsgroup, the
following link is still applicable for MS Access:
http://www.aspfaq.com/etiquette.asp?id=5006, and
is excellent when it comes to detailing how to
provide the information that will best enable
others to answer your questions.


Sincerely,

Chris O.
 
Sounds like you have used an expression to create a column. Expressions
cannot be updated. The other columns of the query should still be updatable
unless there is some other problem such as the use of an aggregate function
such as Max() or Sum().
 
Back
Top