Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2003

    Talking Unanswered: Keeping locale when compacting MSAccess database through JRO

    Hi there!

    Im compacting an Access database by using the JROs 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 Im putting my trust in you, the good people of this forum.

    Any ideas, comments or insights are greatly appreciated.

    Kind regards



    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.

    Last edited by whoohaa; 09-17-03 at 10:17.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts