Information sort on ODBC

  • Thread starter Thread starter OssieMac
  • Start date Start date
O

OssieMac

In my searches for info on various aspects of programming within Access I
keep seeing references to ODBC. If I am interpreting correctly, there are 2
types of databases in Access; the one I use and plus ODBC.

I would like someone to point me in the right direction to get some more
information on this subject so that I might try to fully understand it. My
major question is are they fully compatible with each other?

Your replies will be greatly appreciated.
 
ODBC = Open Database Connectivity

ODBC Drivers are provided by makers of many server and/or desktop databases
and third-party providers to allow use of those database engines with front
ends. Access can use any ODBC-compliant database as a database engine,
except Access' own default engine(s), Jet and ACE (ACE is new with Access
2007, but is 'descended' from 'Jet'). Some ODBC drivers are included with
the install package of Access / Office Pro; others must be obtained by the
database vendor, or from a third-party source.

In the past, I have used Access, Jet, and linked tables in ODBC-compliant
databases since the days of Access 2.0. Only once or twice since 1993 have I
encountered any errors. Databases with which I've used ODBC connections
included Informix, Sybase SQL Server, and Sybase SQL Anywhere.

BTW, "Google is your friend"... almost all the information I included here,
and much more, is available by searching in Google's Advanced Search for
"ODBC".

Larry Linson
Microsoft Office Access
 
Thanks Larry
--
Regards,

OssieMac


Larry Linson said:
ODBC = Open Database Connectivity

ODBC Drivers are provided by makers of many server and/or desktop databases
and third-party providers to allow use of those database engines with front
ends. Access can use any ODBC-compliant database as a database engine,
except Access' own default engine(s), Jet and ACE (ACE is new with Access
2007, but is 'descended' from 'Jet'). Some ODBC drivers are included with
the install package of Access / Office Pro; others must be obtained by the
database vendor, or from a third-party source.

In the past, I have used Access, Jet, and linked tables in ODBC-compliant
databases since the days of Access 2.0. Only once or twice since 1993 have I
encountered any errors. Databases with which I've used ODBC connections
included Informix, Sybase SQL Server, and Sybase SQL Anywhere.

BTW, "Google is your friend"... almost all the information I included here,
and much more, is available by searching in Google's Advanced Search for
"ODBC".

Larry Linson
Microsoft Office Access
Click to expand...
 
Back
Top