Downloads

• Solution of Acc2000 Termination Bug

• Building Import/Export specs in VBA

  These sample databases show how to bypass MS Access 2.0 <-> MS Access 7.0/8.0 text files import/export interface incompatibilities and BTW solve the problem of MS Access 7.0/8.0 Import/Export Wizard "excessive shrewdness".

  • Download Access 2.0 sample database (imex20.zip - 28661 bytes)
  • Download Access 95 sample database (imex95.zip - 59382 bytes)
  • Download Access 97 sample database (imex97.zip - 37654 bytes)

   

• Is it a bug or feature ?

  The sample databases for MS Access 97 and MS Access 2000 demonstrate "Termination bug". This bug was first described for MS Access 97 by Marek Kepinski (MKepinski@impaq.com.pl) in his article on WWDN (this site is down now) and in his article in Smart Access in December 1998. Unfortunately bug seems to be NOT fixed in MS Access 2000. But similar VB 6.0 code works correctly! 

  • Download MS Access 97 and MS Access 2000 sample databases and VB 6.0 project (bugorftr.zip - 54685 bytes)

    Read more about "Termination bug" here: http://support.microsoft.com/support/kb/articles/q223/2/45.asp

• A method to modularize MS Access applications

  This sample application shows a method which can be used to modularize MS Access applications. It consists of:

  1. shell application (Shell.mdb);
  2. two library mdbs (utilslib.mdb and objlib.mdb);
  3. eight application objects mdbs (Analysis.mdb, Category.mdb, Customer.mdb, Employee.mdb, Order.mdb, Product.mdb, Shipper.mdb and Supplier.mdb);
  4. VB 6.0 project, source files and ActiveX .dll (ShipperVB.dll) of VB version of Shipper application object (to activate ShipperVB.dll through Shell.mdb you have to register it using regsvr32.exe and you have to have VB 6.0 runtime installed on your PC - if you don't have VB 6.0 runtime - just ignore the part of the sample which uses ShipperVB.dll ActiveX dll);
  5. back-end data mdb - nw_db.mdb.

  The directories and files' fullpaths of sample application are hardcoded - to install it:

  1. create directory c:\nwc ;
  2. copy sample's zip archive nwc.zip into it ;
  3. unzip nwc.zip.

  After unzipping you should get the following directories and files:

  Directory of C:\nwc
  
  app
  objects
  data
  libraries
  vb
  
  Directory of C:\nwc\app
  
  Shell.mdb
  
  
  Directory of C:\nwc\objects
  
  Analysis.mdb
  Category.mdb
  Customer.mdb
  Employee.mdb
  Order.mdb
  Product.mdb
  Shipper.mdb
  Supplier.mdb
  
  
  Directory of C:\nwc\data
  
  nw_db.mdb
  
  
  Directory of C:\nwc\libraries
  
  objlib.mdb
  utilslib.mdb
  
  
  Directory of C:\nwc\vb
  
  ShipperVB.dll
  <source Files of VB project>
  

  Start MS Access 97 and open sample app's Shell.mdb (c:\nwc\app\Shell.mdb). Play with it a little. Investigate source code. Ask you questions and send your comments (mailto: shamil@marta.darts.spb.ru)... 

• Download sample application (nwc.zip - 572810 bytes)