5

I have an MS Access database. All names (tables, field, data, etc.) are in Ukrainian. Both my Access and Windows are English. Here is what happens when I try to type a name of table in Ukrainian in VBA editor:

1

The same thing with all identifiers. And obviously this code doesn't work. Any way to fix it without renaming everything?

Improve this question

2 Answers 2

Reset to default
3

Unfortunately the VB Editor doesn't support Unicode, but rather uses the code-page of the current Windows language. In order to edit the code, you'll need to either change the names of the Access tables, queries and fields to English, or, change the Windows code-page to Ukrainian.

There was once a time when VBA supported locale-specific keywords, but the VBA language keywords, in modern VBA, are all in English.

My preference would be changing the Access names to English, but you might have other considerations.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I would do both: names in English or translit will cause less problems in any case, especially if you suppose to use the application in environments with different codepages, also you will be able to write comments in Ukrainian.
1

I just finished my work with that database and came back here to say: if you faced such a problem - just change your system code-page. I tried to just rename my tables instead. And it was a mistake. You'll make your life much easier if you don't try to use MS Access DB with non-system language.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.