microsoft access training course - access query recordset

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training course - Access Query - Recordset is not updatable | Access forum

microsoft access training course - Access Query - Recordset is not updatable | Access forum

resolvedResolved · Low Priority · Version Standard

Adrienne has attended:
Access Introduction course

Access Query - Recordset is not updatable

Hi

I've made a new query from a variety of tables, but I cannot enter data in the query. When trying, it reads in the comment box left corner that the "Recordset is not updatable".

The relationships seem all right. Could you pelase advise?

Thanks

Adrienne

RE: Access Query - Recordset is not updatable

Please ignore this request! I've found out what I did wrong. I'm afraid that although I said that the relationships seemed all right, they were not. I accidently had selected the same table twice. By removing one it allowed me to enter data again.

Regards

Adrienne


 

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips


Server loaded in 0.11 secs.