Delphi Russian Knowledge Base
DRKB - это самая большая и удобная в использовании база знаний по Дельфи в рунете, составленная Виталием Невзоровым

Opening Access (early binding)


Before you can use this method, you must have imported the type library (MSAcc8.olb for Access 97).

One way of starting Access is Excelto try the GetActiveObject call, to get a running instance of Access, but put a call to CoApplication.Create in an except clause. But except clauses are slow, and can cause problems within the IDE for people who like Break On Exceptions set to True. The following code removes the need for a try...except clause, by avoiding using OleCheck on GetActiveObject in the case when Access is not running.

  uses Windows, ComObj, ActiveX, Access_TLB;
    Access: _Application; 
    AppWasRunning: boolean; // tells you if you can close Access when you've finished
    Unknown: IUnknown; 
    Result: HResult; 
    AppWasRunning := False;

    {$IFDEF VER120}      // Delphi 4
    Result := GetActiveObject(CLASS_Application_, nil, Unknown); 
    if (Result = MK_E_UNAVAILABLE) then 
      Access := CoApplication_.Create 
    {$ELSE}              // Delphi 5
    Result := GetActiveObject(CLASS_AccessApplication, nil, Unknown); 
    if (Result = MK_E_UNAVAILABLE) then 
      Access := CoAccessApplication.Create 
    else begin 
      { make sure no other error occurred during GetActiveObject } 
      OleCheck(Unknown.QueryInterface(_Application, Access)); 
      AppWasRunning := True; 
    Access.Visible := True;

Without using the type library

Automation is so much easier and faster using type libraries (early binding) that you should avoid managing without if at all possible. But if you really can't, here's how to get started:

          Access: Variant; 
            Access := GetActiveOleObject('Access.Application');    
            Access := CreateOleObject('Access.Application');    
          Access.Visible := True;