Manipulate SQL 2005 with Access 2007 adp project files

[Guest]

We use Access 2003 adp files to do massive amounts of work on SQL databases
that Access simply can't handle. Be it, creating/editing tables, stored
procedures, using macros to run many stored procedures in sequence etc. We
do this because we never have to write code (which would slow development
time down tremendously) and we can run stored procedures on 'big data' that
access simply can't handle.

We may be 'forced' to upgrade to SQL 2005 soon and I’ve been reading that it
may not be possible to do the far superior things that ADP files are capable
of in SQL 2005 with Access 2007. Is this really true? Did we really just
take a gigantic step backwards?

If so, are there other graphical front ends out there that allow table,
stored procedure, macro manipulation? Or are we supposed to ‘never’ upgrade
to prevent us from doing 8 times the amount of work to achieve the same goal.

 

[Rick Brandt]

We use Access 2003 adp files to do massive amounts of work on SQL
databases that Access simply can't handle. Be it, creating/editing
tables, stored procedures, using macros to run many stored procedures
in sequence etc. We do this because we never have to write code
(which would slow development time down tremendously) and we can run
stored procedures on 'big data' that access simply can't handle.

We may be 'forced' to upgrade to SQL 2005 soon and I've been reading
that it may not be possible to do the far superior things that ADP
files are capable of in SQL 2005 with Access 2007. Is this really
true? Did we really just take a gigantic step backwards?

If so, are there other graphical front ends out there that allow
table, stored procedure, macro manipulation? Or are we supposed to
'never' upgrade to prevent us from doing 8 times the amount of work
to achieve the same goal.

I have heard that an Access 2003 ADP cannot do most of those things against
a SQL Server 2005 back end, but I would expect one built with Access 2007 to
be able to.

On the other hand you don't have to use ADPs to do any of that.