Using Ado and SQL in non-English office installation

Hi,

Trying to do this in an non-English Office 2016 installation.

Please Login or Register  to view this content.

The last line fails to open the as the bLimit evaluates as true/false in non-English language. The SQLString becomes in this case "SELECT Process.ProcessName FROM Process WHERE Process.IsApproved = True And Process.HasOutdoors = Sant". (Sant is True in Swedish).

How do I work around this? Is there any setting in VBA where you force variables to be english? I want my macro to be installation independent.

I could of course write

Please Login or Register  to view this content.

And use this instead of bLimit. But my VBA program is much larger than this, and I wouldn't want to search/replace all these issues in SQL queries.

Thanks in advance,
Johan

What database are you connecting to?

Access database file (.mdb)