Unanswered: Keeping locale when compacting MSAccess database through JRO
I’m compacting an Access database by using the JRO’s CompactDatabase. I do this from an ASP-page (Vbscript) on a webserver. It all works fine but I have now realized one big problem with this though. Whenever the database is compacted the locale for sort order is lost resulting in Swedish characters not being sorted in the right order.
I have no idea how to resolve this issue so I’m putting my trust in you, the good people of this forum.
Any ideas, comments or insights are greatly appreciated.