[Gjslick]

You have spaces in the column names in your query. You can't just have "first name", this confuses the query parser. That should be changed to either "firstName" or "first_name". A column name basically shouldn't have a space in it.

I highlighted the problems in red below:

<cfquery datasource="b1008321-access">
UPDATE Member
SET first name='# FORM.first_name#', last name='# FORM.last_name#', address='# FORM.address#', Town='# FORM.Town#', date joined='# FORM.date_joined#'
WHERE memberID = #memberID#
</cfquery>

I'd recommend losing the spaces, but if you *really* need to keep them, then you need to surround each column name that has spaces with square brackets in your query. For example, you could change your query to this: (with a little better formatting...)

<cfquery datasource="b1008321-access">
    UPDATE
        Member
    SET
        [first name] = '#FORM.first_name#',
        [last name] = '#FORM.last_name#',
        address = '#FORM.address#',
        Town = '#FORM.Town#',
        [date joined] = '#FORM.date_joined#'
    WHERE 
        memberID = #memberID#
</cfquery>