Do Not use the word "Name" for a field that is linked

[Guest]

I used the word "Name" for a field in a table that contained vendor names
that was linked to a tablethat contained accounting information that used the
word "Name" for a fiield. The table will not synchronize. As soon as I
changed the name to "VendorName" I was okay.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...7557c4e3a8b0&dg=microsoft.public.access.forms

 

[Ken Snell \(MVP\)]

The reason you may have problem with Name as a field name is because Name is
a reserved word in ACCESS and should not be used as the name of a field,
control, table, form, etc. That can confuse ACCESS. See these articles for
more information:

List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266

Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763