ADO AV

From: NZTed (nzted**Remove**_at_paradise.net.nz)
Date: 02/17/05


Date: Thu, 17 Feb 2005 18:03:49 +1300

Greetings
I am at last moving from DAO to ADO. But problem exists with use driver
other than ODBC.

Database MSAccess
Delphi 7 Enterprise
Win XP (Home) with SP2 (MDAC2.8 - all items present.)
Error occurs with ADOConnection
Provider: Microsoft.Jet.OLEDB.4.0
Connection Tests OK

but run code

  Restrictions:=VarArrayCreate([0, 3], varVariant);
  Restrictions[3]:='TABLE';
 ADOConnectyion1.OpenSchema(siTables, Restrictions, EmptyParam,
ADODataSet1);

Access violation at address 1B04F885 in module 'msj40.dll' Read of address
00000008.

I receive the same message if I open a connection with this provider and try
and access
ADOConnection1.GetTableNames(ListBox1.Items);

Thanks in advance for any light that can be shown on this matter

-- 
Ted