Transfer command

[Guest]

I transfer table fields from one database to another.
Everything get's correct transferred except the table field:"date" (I always
get the error message: Invalid syntax)
I checked both tables, they all have the same specification for the field
"date"
I checked the command line to transfer - nothing is misspelled or wrong
written.
Can someone tell me where to look further? Whatelse could be my mistake?

 

[Guest]

"Date" is a reserved word in Access and should not be used as a field name.
IF POSSIBLE, you could rename the field in table design window. Remember
though that if you change a field's name, any queries, controls or code that
reference that field need to be changed too. So while changing a field name
is easy, a lot of work may need to be done elsewhere.

Matt