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).
Read the rest of this entry »Archives for 'January, 2009'
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
January 21st, 2009 by Libor Jelinek
Tags: Access, SQL Server | Posted in: SQL Server | 2 Comments »
en: Highlight current row in Excel using VBA
January 19th, 2009 by Libor Jelinek
Highlighing currently edited row for better user experience that maybe someday buil-in in Excel, meanwhile you must use Visual Basic for Application code to do this. It’s very helpful especially in very wide long rows. In this tutorial I will show you how to employ Excel event model to highligh current row.
Read the rest of this entry »Tags: Excel | Posted in: Etc. | No Comments »
en: Crashing SQL Server 2005 Upgrade Advisor error
January 18th, 2009 by Libor Jelinek
Great tool for migrating from SQL Server 7 or 2000 to new 2005 version can easily crash with strangeful mystery errors if you use Microsoft Update for being up-to-date with .NET Framework. If you have .NET Framework newer than 2.0, Upgrade Advisor failed to analyze database engine component.
Read the rest of this entry »Tags: SQL Server | Posted in: SQL Server | 10 Comments »
cs: JavaScript: Nejnepochopenější programovací jazyk světa
January 11th, 2009 by Libor Jelinek
(Překlad slavného článku Douglase Crockforda.) JavaScript, známý také pod jmény LiveScript, JScript a ECMAScript, is je jedním ze světově nejoblíbenějších programovacích jazyků. Prakticky každý počítač na světě má nainstalován nejméně jeden interpret jazyka JavaScript. Popularita JavaScriptu vznikla z jeho role skriptovacího jazyka pro WWW stránky.
Read the rest of this entry »Tags: JavaScript, překlady | Posted in: JavaScript | No Comments »
