demarc520

Resource Logic Client/Server Development Services

Knowledge Base


  
MBF to IEEE Floating Point Conversion
An example of C# code that converts an MBF floating point byte array to IEEE double precision floating point.
  
Issues in Converting Microsoft Access 97 to Microsoft Access 2000
Migrating Microsoft Access 97 applications to Access/2000 is works fairly well.  Certain complex conditionals don't compile, but these expressions can be fixed fairly quickly.  Most of the rest of the process is straightforward.
  
Issues in Converting Microsoft Access 97 to Microsoft Access 2000 projects
Migrating Microsoft Access 97 applications to Access/2000 and SQL is complicated by difficulties converting queries.  Most of the rest of the process is straightforward.
  
Altering a table with a large number of columns
Enterprise Manager Table Designer does not provide slots for adding any more than 255 columns.  For large tables, it is necessary to use a 'bag of tricks' to change the table definition and migrate data.
  
Converting a wide (many column) SQL-Server table to a series of rows
In some circumstances a developer or database designer is stuck with a situation where it is necessary to extract data from a very wide (unnormalized) table and put groups of these columns in succeeding rows.
  
Flat File Bulk Import to SQL Server 2005
Stored procedures that import flat file with 880,000+ records in a few managable steps.  File appears to be a Unix export since it does not use CRLF typical of MS-DOS/Windows text files.
  
Using VBA to extract data from an Excel spreadsheet
Extract transaction data from Excel spreadsheets.
  
A quickie Wizard for converting textboxes into checkboxes
The Access form creation wizard brings in bit fields (or yes/no columns) as textboxes, when the user typically wants check boxes. For a form with a large number of these, this wizard can be used to 'clean up' the form.