Re: Alternatives to ADP?
- From: "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
- Date: Sat, 20 Oct 2007 21:45:19 -0400
With MDB and ODBC linked tables, simple queries should be done on the
server, not locally. Simplify them or use Views and make sure that you
don't use VBA function in any JOIN or WHERE statements. Take a look with
the SQL-Server Profiler to make sure that your queries are executed on the
server, not locally.
For ADP, don't expect any new features in the future but I will be surprised
if MS is ever dropping the support for ADP without giving a replacement
solution: don't forget that a lot of big companies are relying on ADP at
this moment.
As alternatives, you can either use unbound forms in Access or go with .NET.
Finally, don't forget that even if you decide to go with ADP, you are not
really blocking the future growth because you will be able to develop in
parallel with both ADP and .NET and that a lot of T-SQL code will be
reusable with .NET because your queries will be already on the server.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"el zorro" <elzorro@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:154C6D3B-2225-4F22-BC2D-1BFC99597C0E@xxxxxxxxxxxxxxxx
I am currently experimenting with upsizing a front end/back end Access 2000
database (via the upsizing Wizard) and have found that keeping the front
end
an mdb with the back end converted to SQL Server 2000 results in
excruciatingly SLOW execution speeds for the queries. As I understand it,
this is because the queries (about 50 of them) are being executed on each
workstation, not the server. Some of these queries are pretty complex, but
they are essential for most, if not all, of the reports and forms to
function
correctly.
So I am now testing the other upsizing option that creates an adp file.
Only
about half of the queries made the migration successfully, but preliminary
testing of the partsthat do work indicates that the adp approach will
result
in much faster
response times for the user.
HOWEVER, I am concerned about the posts that suggest Microsoft is
dropping support for adp. One of the reasons I have been asked by the
Powers
That Be to upgrade the database is to allow for future growth. I'm not
sure I
can claim that adp is the future.
Are there any long term alternatives to adp that will allow me to migrate
to
a more robust platform (with the queries on the server) without having to
completly reprogram my current Access database?
Thanks!
.
- Follow-Ups:
- Re: Alternatives to ADP?
- From: Tom van Stiphout
- Re: Alternatives to ADP?
- Prev by Date: Re: 2 MS Access validation Q's
- Next by Date: Re: Alternatives to ADP?
- Previous by thread: Re: 2 MS Access validation Q's
- Next by thread: Re: Alternatives to ADP?
- Index(es):
Relevant Pages
|
