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;

Отправить комментарий

Антиспам проверка