Is there any concise documentation on how to access an MSAccess database
from Delphi 3.02/BDE5.01?  Is ODBC necessary, or should the native driver
work properly?  I keep bumping into problems with passwords, and Dephi
can't/won't open the tables.

Alan B. Hartmann

the native BDE Access driver does not need ODBC.   It does require that you have
DAO installed on each machine you want to use the BDE driver for and that you
have the DLL32 parameter in BDE config correctly set for he version of DAO that
is installed.

The default user name for Access tables is Admin with no password
If that does not work then some one has set up security with Access on your
system.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

I'm running Access 97, BDEAdmin says "IDDA3532.DLL" for the DLL32 parameter,
is that correct?

Part of the confusion is that in BDEAdmin, some of the settings appear to be
duplicated on the Drivers and Databases tab.  This is how I have it set up:

Drivers
    DatabaseName        left blank
    System Database    C:\Windows\System\System.MDW
    User Name                Admin

Database
    DatabaseName        C:\...\MyDatabase.MDB
    System Database    left blank
    User name                left blank

Can you clarify what the intention is of having these settings duplicated on
Drivers and Databases?  I have assumed that entries on the 'drivers' tab
establishes defaults for all MSAccess aliases, and Databases establishes
overrides for the particular alias. If my assumption is correct, the alias
I've defined should point to the correct database, the correct system
database, and the correct user name.

When I launch Access, I must provide a login name (Admin) and password.
When I open the table, I also provide a password.

In BDEAdmin, if I attempt to open the table with the above settings, I get
External Exception EEFFACE.

That is correct

Are you using NT?  I recognize this as an error message that is a problem on NT
with Service Pack 4 and 5 installed.

Try this solution with setting a registry key

1 go to the key:

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Currentversion\Image file
execution options

2 Add a key for your application, f.i: myapp.exe

3 Add a value to the newly created key:

Value name: DisableHeapLookAside
Data type:     REG_SZ
String:           "1" (without quotes)

More info: MS Kb articles Q195008 and Q195009

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Brian:

I'm running Win98, not NT.

...
...

Well I can set up an alias just like you specified and get it to open an Access
table so as far as I can tell your problem is not in the alias setup.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com