Best Front End

[Jose Carlos]

What is the best program to building front ends to work with SQL server 2000
or 2005?

I'm using ADP with MS Access 2003, I think the best vantadge is the
integration with the Ms Office.

Few days ago I read somthing about Visual Studio 2005 Team Edition for
Database Professionals.

Somebody else can tell me if this program is really great for create fron
end to work with SQL server 2000 or 2005?

Thanks

JCP

 

[Norman Yuan]

When people say "Front end", it usually means an application's user
interfaces, while what you mentioned here (ADP, or Visual Studio, team
edition or not), is development tool/environment. Of course ADP, comparing
to VS, is specificly designed for SQL Server, and can only develop/be used
as a deskop application, while VS is used for developing more wider ranged
of applications, or all type of applications on MS's platform, Windows
desktop, web application, mobile device application....

As for which is best front end for SQL Server, it is entirely depends on
what kind of application user need. In certain ciucumstances, ADP might be
suitable the best, in the other cases, ADP could be the least possible
candidate. And, do not forget, ADP already reaches its end of life and may
not be included in next MS Access version, so for a new development, ADP is
unlikely among the best front end choices any more.

 

[Baz]

Access is almost always a vastly more productive development environment for
database applications.

ADP's are on the way out (sadly, 'cos I like them), so I wouldn't recommend
anyone to start a new application using an ADP (regardless of whatever
foul-mouthed garbage you might hear from Kempf or one of his pseudonyms).

 

[Tom Wimpernark]

Norman

you're full of crap bitch, MDB already reached it's end of life; and from
what I've read firsthand-- Microsoft guarantees that Office Web Components
will be supported through the end of 2013

 

[Tom Wimpernark]

Baz

i'm not foul-mouthed, I stand up for the truth

 

[Baz]

Looks like Kempf has another pseudonym.

Norman

you're full of crap bitch, MDB already reached it's end of life; and from
what I've read firsthand-- Microsoft guarantees that Office Web Components
will be supported through the end of 2013

 

[Baz]

Whatever...

Baz

i'm not foul-mouthed, I stand up for the truth

 

[PMK]

I just asked almost the same question after playing around with Visual
Studio 2005 then saw this thread...

So if we don't use adp then what? Will there be another way to put the
back end on SQL Server?

Peter

 

[Baz]

Of course: ODBC linked tables, same as we were doing for years before
Microsoft's flirtation with ADP's. Well established technology, works good.