Re: Need ODBCDirect-ion
- From: "Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxxx>
- Date: Sat, 19 May 2007 02:12:58 -0600
Upsizing slows the apps down too much, so I did some research and stumbled
on some dry documentation on ODBCDirect. I managed to set up the
connection
code but now I'm at a loss as to what's next.
Just as a side note, ODBC, or so called "jet" direct is simply a way to
by-pass
JET.
It is essentially the pre-cursor to ado.
however, using a plane Jane odbc connection, and making a query pass-through
will yield the same performance anyway.
Also, notE that ODBC jet direct has been discontined in a2007.
There is zero gains to be made using ODBCdirect over that of pass-through
queries anyway. Further, none of this odbc direct stuff applies to your
current forms anyway.
Do I need to code what Access used to take
care of naturally with regards to Form Recordsource and listbox/combobox
Rowsource properties?
No, for the most part if you going to adopt un-bound forms, then ms-access
is the wrong tool. (the reason being is that vb, and vb.net has a HUGE
support system, and a bunch of wizards built around un-bound forms. If you
decide to go the un-bound forms way, then ms-access is the wrong tool
because its forms are bound, and all of the tools are desgined around this
type of approach. So, you wind up with the worst tool if you go un-bound.
So, either you get great performance out of your bound forms, or you dump
ms-access. it really that simple....
Can anyone suggest a direction or some "how to" sources?
You need experience with sql server. you have to get competent with it. As
my other post states, the performance of using sql server with c++,
assumbler, a web site, or ms-access sis going to be about the same (sql
server does all of a sudden, go..hey..this is a web server).
It all about you going back to your mainframe roots, and moving an absolute
min of data.
For example, it been about 10 years since I opened a form that is attached
to a large table without a where clause. So often, I seen a form that
attached to a table with 10,000 records. if 5 people open that form, we
potential transfer 50,000 records of data, and NOT DONE ONE BIT of useful
work.
here is some links:
http://support.microsoft.com/default.aspx?scid=kb;en-us;175619&Product=acc
ACC2000: "Access 2000 Upsizing Tools" White Paper Available in Download
Center
http://support.microsoft.com/?id=241743
ACC2002: "Access 2002 Upsizing Tools" White Paper Available in Download
Center
http://support.microsoft.com/?id=294407
ACC2000: Optimizing for Client/Server Performance (odbc)
http://support.microsoft.com/?id=208858
ACC: "Upsizing to Microsoft SQL Server" White Paper Available in Download
Center (a95, and a97)
http://support.microsoft.com/?id=175619
HOW TO: Convert an Access Database to SQL Server (a97,a2000)
http://support.microsoft.com/?id=237980
ACC: Choosing Database Tools White Paper Available in Download Cente
The Choose.exe file contains a document called "Choosing the Right Database
Tools" that discusses Microsoft's database products: Microsoft Access,
Microsoft FoxPro, Microsoft SQL Server, Microsoft Visual Basic, and Open
Database Connectivity (ODBC). Use this document to decide which database
tool is right for you.
http://support.microsoft.com/?id=128384
ACC: Tips for Optimizing Queries on Attached SQL Tables
http://support.microsoft.com/?id=99321
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
--
.
- Prev by Date: Re: Users create reports in MDE file
- Next by Date: Re: Need help with syntax
- Previous by thread: Re: Need ODBCDirect-ion
- Next by thread: Re: Users create reports in MDE file
- Index(es):
Relevant Pages
|
