Re: a97 to a03 and DAO to ADO
- From: "Brendan Reynolds" <anonymous at discussions dot microsoft dot com>
- Date: Fri, 22 Apr 2005 12:01:05 +0100
You can use both ADO and DAO in the same MDB, Mario, as long as you're
careful to disambiguate when using objects that have the same name in both
libraries (Dim rst As ADODB.Recordset and Dim rst As DAO.Recordset, rather
than just Dim rst As Recordset). So rather than trying to convert all the
code at once, you could leave most of the code alone and try to identify the
specific procedures that you believe may benefit from using ADO.
--
Brendan Reynolds (MVP)
"Mario G." <MarioG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E102B952-88F5-486A-ADFD-F22313904236@xxxxxxxxxxxxxxxx
> Hi Allen,
>
> As a VB Developer, I know the performance benefits of utilizing ADO over
> DAO.
>
> The Access DB I am asked to upgrade utilizes a combination of Access
> tables
> and SQL Server tables through ODBC. I was under the assumption that the
> performance gains realized in ADO in VB would translate into similar gains
> in
> Access.
>
> Would this not be the case?
>
>
>
> "Allen Browne" wrote:
>
>> Why do you need to change the code to ADO?
>>
>> DAO is the native Access library - the one that Access itself uses.
>> If you are using JET tables (the tables in Access), then DAO is still the
>> most appropriate library to use.
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia.
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>> "Mario G." <MarioG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:4BFC6F94-5963-4F43-833B-1007A8C695AD@xxxxxxxxxxxxxxxx
>> >I am preparing to convert an Access 97 mdb to Access 2003. I've
>> >similated
>> > the upgrade using Access 2000 with no problems. However, I also need
>> > to
>> > upgrade the code from utilizing DAO 3.6 to ADO.
>> >
>> > Does anyone have any good references for this (books, web sites,
>> > etc....)
>> > Has anyone done this? What problems did you encounter and had to
>> > resolve.
>> >
>> > Thanks.
>>
>>
>>
.
- Follow-Ups:
- Re: a97 to a03 and DAO to ADO
- From: Mario G.
- Re: a97 to a03 and DAO to ADO
- References:
- a97 to a03 and DAO to ADO
- From: Mario G.
- Re: a97 to a03 and DAO to ADO
- From: Allen Browne
- Re: a97 to a03 and DAO to ADO
- From: Mario G.
- a97 to a03 and DAO to ADO
- Prev by Date: Pagination code in jsp.
- Next by Date: Re: mdb to adp conversion
- Previous by thread: Re: a97 to a03 and DAO to ADO
- Next by thread: Re: a97 to a03 and DAO to ADO
- Index(es):
Relevant Pages
|
