Here's my query:

$sth = $dbh->prepare("INSERT INTO tblCustomer (BranchID, LastName, Fir
+stName, Street, Town, County, PostCode, PhoneNumber, Email, FAX, Note
+) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
");

$sth->execute(
    'L1',
    $secondname,
    $firstname,
    $order->{addresses}->{delivery}->{street},
    $order->{addresses}->{delivery}->{city},
    $order->{addresses}->{delivery}->{county},
    $order->{addresses}->{delivery}->{postcode},
    undef,
    'rjberry@gmail.com',
    undef,
    'Order ID #' . $id
) or die "Could not update DB!";
[download]

(simplistic code, I know. I'm just writing a small program to transfer orders from the website to the EPOS system at the place I work ... )

I don't have MS Access to test this right now, but it could be that Access doesn't like the trailing semicolon at the end of your query.