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

Resolved · Low Priority · Version Standard

Tue 13 Nov 2007, 12:40 Delegate Adrienne said...

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

Tue 13 Nov 2007, 12:52 Delegate Adrienne said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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