en: Access linking/importing error: 3125: is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long

Solution: 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.

<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)

Tags: , . This entry was posted on Wednesday, January 21st, 2009 at 1:36 pm and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

3 Responses to “en: Access linking/importing error: 3125: is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long”

  • Your Reader says: (January 27, 2009 at 9:59 pm) Reply

    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) Reply

    Surely! I welcome your feedback. And greetings to Russian!
    Libor

  • bumsmomsrit says: (February 5, 2009 at 11:08 pm) Reply

    Your site displays incorrectly in Explorer, but content excellent! Thanks for your wise words.

Leave a Reply

Sidebar decoration image
Copyright © 2001-2009 Virtage Software. Virtage is registered trademark of Libor Jelinek.
Developer blogs and tutorials Virtage Developer is proudly powered by WordPress.