Solution to this annoying bug is to rename object. Make it shorter, without special chars (, -, .). Depends on your database from you are linking or importing from. Unfortunatelly, SQL Server 2000 by default produce these Access unacceptable names for table’s primary keys (e.g. PK__master.PrioritaP___6AA6A67A).
I exprience this problem on SQL Server 2000 Standard and Access 2003. Complete error message if you click on Help button:
<Name> is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. (Error 3125)
The specified name does not follow standard naming conventions or is not a valid parameter or alias name. Check your entry to make sure you have not included invalid characters or punctuation and that the name is not too long.
I hadn’t time to more investigation. If you are really interrested, yahoo ( or google) for it.
Your Reader says: (January 27, 2009 at 9:59 pm)
Good work! Thank you very much!
I always wanted to write in my site something like that. Can I take part of your post to my site?
Of course, I will add backlink?
Sincerely, Your Reader
admin says: (January 27, 2009 at 10:21 pm)
Surely! I welcome your feedback. And greetings to Russian!
Libor