COMPANY PRODUCTS DOWNLOADS CONTACTS TIPS & TRICKS

  • Access
  • Access 97
  • SQL Server
  • Visual Basic
  • SQLConvert utility

    A small utility converts MS SQL Server fields from/to Unicode

    This utility helps developers to convert most sensitive to Access field types. Access 97 do not correctly work with Unicode fields in MS SQL Server 2000 table - it set all fields to "default" type, with length 255. In other case, while working with Access 2000 or later it is beneficial to have Unicode type fields, so users can use any language to enter text.

    Other known problem for Access that Real (or Single in VBA) data type it incorrect "rounded", as 7.2 become 7.20000000001 and so on, and preferred data type it Float (Double)

    Using this utility you can easy convert fields from and to Unicode, and between Real and Float.

    In order to run this utility it is required to have MS SQL Server 2000 client tools installed. Also requires VB runtime and Point library files apDLLUpdate.EXE

    Utility was build on Visual Basic 6.0 by Alexander Feduleev

    For questions please contact: Support

    Download: SQLConvert.zip (86 kb)

    ©2024 Point International Limited.  All rights reserved. Privacy Statement