News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, May 20, 2010

Language support in VBA

Today I got this message from blog reader:

So I'm working on some app in access 2003 via vba and I need to use macedonian language with Cyrillic characters, so as you are Russian you might know something abot this...

The matter is that I can't make VBA editor to recognize Cyrillic characters...  I tried on other computers and it works but not on mine... I set VBA editor to font which support Cyrillic characters, so now  characters are shown properly in vba editor, but vba does not  recognize them i.e if I write msgbox "кирилица" msgbox dialog doesn't show them in Cyrillic or if

So, the trick was to  set proper language for non-Unicode programs in Control Panel-Regional and Language Options-Administrative-Language for non-Unicode programs. VBA still does not fully support Unicode, so you have to be aware these language settings!


Thursday, May 13, 2010

More on database compare

Here two programs to perform Access database structure comparison:

StarInix Database Compare, free, but not working with Access 2007 accdb format, looks like it is outdated.

DbWeigher, not free, but, as my friend reported, work quite good. You can compare visually or get SQL script for database changed

Labels: ,

Wednesday, May 12, 2010

Access 2010 Runtime

Download Access 2010 Runtime (in 13 languages), Access Database Engine Redistributable (both in 32 and 64 bit versions!) and Source Code Control Add-in for Access.

via The official blog of the Microsoft Access product team