Hi there!

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.

Kind regards

W.H.

---------------------Solved!---------------------

test.CompactDatabase("Provider=Microsoft.Jet.OLEDB .4.0;" & "Data Source=c:\Old.mdb;" & "Jet OLEDB:Don't Copy Locale on Compact=True;", "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=c:\New.mdb;" & "Locale Identifier=1053")

Just wanted to share if anyone searches the forum for something like this later on.

W.H.