RE: linking to SQL databases
- From: "Dirk" <Dirk@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 14 Dec 2005 02:12:02 -0800
As far as I know you can not configure ADO connections outside of code in
Access 2003 or earlier. ADO recordsets are incompatible with the Access
controls and can therefore not be used to populate them. You could however
open a DAO connection to the MS-SQL database which should result in DAO
recordsets which can be used to link to controls.
Your queries do not have to change because of the change from DAO to ADO.
They might need to change because the Jet database engine uses a different
dialect of SQL than MS-SQL's. I do not know the details of these differences
though.
"maxzsim" wrote:
> Hi,
>
> Is ODBC linked-table the only way to have a pre-defined link to SQL
> databases ?
>
> can it somehow be linked as ADO (or it must be done thru programming) ?
>
> i have already an access program that is running but i am thinking of
> speeding it up as it's getting slower.
>
> if i set up a link to the SQL database via ADO programming , how do i
> actually get the existing queries to work or it has to be changed as well
>
> kindly advise
.
- Follow-Ups:
- RE: linking to SQL databases
- From: maxzsim
- RE: linking to SQL databases
- Prev by Date: RE: Need to develop a simple search tool
- Next by Date: FAO Alex Dybenko (MVP) - Missing Reference
- Previous by thread: Delay committing transaction
- Next by thread: RE: linking to SQL databases
- Index(es):
Relevant Pages
|
