Sounds like you bought the Std version and are trying to use ODBC
drivers.  Std does not allow the use of ODBC drivers.  You will have to
use the Native driver for MSAccess.  This is the MSACCESS driver and not
the Microsoft Access Driver (*.mdb).  The first is the native driver
into DAO while the second is the ODBC driver and Std cannot use ODBC
drivers.

Jeff Overcash

Are you trying to use the native BDE driver or the ODBC driver?

Assuming the native driver, create an alias using the BDE Administrator.
Choose MSACCESS  as the driver type. Change the DLL setting for the MSACCESS
driver to IDDA3532.DLL.

In your application use a TDatabase component. Set the AliasName property to
the alias you created in the BDE Administrator. Set the Database name
property to any name you care to use to identify the database within your
program. Use this name in the DatabaseName property of all of your dataset
components (TTable, TQuery). Set the LoginPrompt property to False.

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
 for any other reason remove nospam from my address.)

I have just purchased Delphi 4 and it is supposed to be able to let me use
Access 97 local databases.
If I assign a table that datatype and try to use it, it tells me that this
application is not able to use it. In fact it will not let me us anything
except the DBDEMO option.

What is going on? I have looked everywhere to find a solution.

John Latham

At the risk of stating the bleeding obvious <G>, I trust that Access
(DAO3.5) is installed on the PC?

news:7d6d65$j6s24@forums.borland.com...

I've got two megs worth of notes on this problem, and pictures of the step by
step hoops you need to jump through to get it hooked up.  But it will
eventually work.
I'll e-mail this to you directly.
john

--

John Santora

Viridian Technologies, Inc.
2 Tanglewood
Aliso Viejo, CA 92656

Phone: 949-362-0263
Fax:     949-362-4830
Web:   http://www.ViridianTech.com

Hello,
Is it possible not to use BDE and ODBC to access MsAccess database in Delphi4
C/S ??

BEst regards,
Eric

--
     _                                                  _
    / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
   / /  |                                            |  \ \
 _( /_  | _   Chow Hoi Ka, Eric                    _ |  _) )_
(((\ \> |/ )                                      ( \| </ /)))
(\\\\ \_/ /   E-Mail : d951...@sftw.umac.mo        \ \_/ ////)
 \       /                                          \        /
  \    _/     http://www.sftw.umac.mo/~d951686/      \_     /
  /   / |____________________________________________| \    \
 /   /                                                   \    \

There are third party components the will provide Access support without the
BDE. Two that I am aware of are Diamond Access and Opus Direct Access.

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
 for any other reason remove nospam from my address.)

news:7fdvra$qv69@forums.borland.com...

They are both using the DAO and JET and you don't want that because MS is
shooting down DAO soon for good reasons I must say. You can be cut of of the
options of switching to another DB (although Opus does have very nice
TDatasets replacements, so switching won't be a big burden). If you don't
want the BDE my advise (for now) is to use an ODBC based replacement like
ODBC98 or ODBCExpress. ODBC will not be developed any further but will still
be supported for a long period of time.

Look at http://www.kylecordes.com and at
http://www.microsoft.com/data/tch-vc21.htm

Sooner or later Borland will come with the answer.

--
Edward Spelt
Big Rock Software Automation
ESp...@Casema.net

On Sun, 18 Apr 1999 17:04:21 -0700, "Bill Todd" <b...@nospam.dbginc.com>
wrote:

You can always use ADOSolutio. It uses ADO, but that will bloat your
distribution by around 6-12MB on Windows95 and 6-7MB on NT.

Stefan Paetow
-
InstallShield Software Corporation

Express Newsgroups: news://news.installshield.com/
InstallShield Support: http://support.installshield.com/