I must thank Jason for helping me on this problem.
Jason quickly identified my problem as being the use of reserved access words perhaps 2 or even more!
Jason carefully explained how important it is to have a method whereby reserved words cannot be used.
This is best carried out by applying tbl before the table name so a table could be called tlbproducts
If the table name is tlbproducts
The field names would perhaps be
productsID
productsName
productsDescription
As Description is a reserved word in access productsDescription would not present a problem.
I write this down as a reminder to me for the future and if it helps anyone that's great also.
Many thanks again Jason and I trust I have this all correct!
Regards
John