Hello, everyone:

  I encountered an error with MS Access database (.mdb file).
  while set Table.TableName property I got an error:
  "Gereral SQL error
   -2147221164
   Table
   Alias: MSACCESS."
  I've created an alias "MSACCESS" which use MS Access driver
  by using BDE administrator.
  I can use other database drivers correctly (interbase, dbase
  and paradox).

thanks in advance

herman

You must have ACCESS, EXCEL, VB PRO, or VC PRO installed on the
machine for the "Native" driver to work.  The "Native" driver just
connects to the Jet database engine which is most certainly not
included with Delphi.  If you have Office/Excel/Access 97 then you
must go into the BDE Admin, select configurations, drivers, native,
MSACCESS, and change the DLL32 to IDDA3532.DLL.  TO do this you must
have the BDE 4.51 or later.  Your best alternative (while still using
Delphi) is to use the ODBC Access driver, it's a free download off the
internet, and it is faster then the "native" (IDDA3532) driver anyway.
The default (IDDAO32.DLL) driver is for Access 95 and earlier
databases only, but it's speed is as good or better then the ODBC
driver.

Link to Access ODBC driver:
http://officeupdate.microsoft.com/isapi/goouprem.asp?TARGET=/download...

Good Luck!
___________________________________
Ada, ASM, C++, Java, Pascal, Perl, VB, etc, there is no
one "perfect" programming language.  Each language
has it's strongpoints, they are all simply tools.  
Succesfull programmers learn not to try to tighten
bolts with hammers or pound nails with wrenches.

Richard Rowell
Dynamic Data Solutions

On Mon, 7 Sep 1998 09:51:48 +0800, "herman" <wolfe...@hotmail.com>
wrote:

Richard Rowell,

  I have office97 installed, and I can use access97 ODBC driver to
  access MS Access database. but I cannot use BDE native MSACCESS
  driver. why?

thanks for your help and time

herman

Did you read my whole post?  Go back, and read it again.  Go into the
config as I instructed.

On Tue, 8 Sep 1998 10:46:48 +0200, "herman" <wolfe...@hotmail.com>
wrote: