Re: Question on conversion to ADP

It's hard to believe that it's you, Mary C., who have just wrote that.
However, now that you have wrote it, it will remains on the Internet
forever.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:5ff5i459asr0jo9hpvaufuuqs5uj6gsqh5@xxxxxxxxxx
Basically it boils down flexibility, security and managing server-side
objects. With a linked table app, users can create their own
queries/views and they are saved on the client. Allowing users to
create/save their own views and stored procedures can create
management problems with clutter, assigning permissions, etc. Although
you can work around not caching server-side objects in ADPs by using
XML (etc), it takes a lot more work. That being said, many people find
ADPs tremendously useful for certain scenarios. As with any database
application, there is no "one size fits all" and Microsoft certainly
does not discourage ADPs for those who have weighed the alternatives
and find that ADPs best suit a particular business need.

--Mary

On Sun, 16 Nov 2008 10:20:01 -0800, "Mary Chipman [MSFT]"
<mchip@xxxxxxxxxxxxxxxxxxxx> wrote:

Is there a particular reason that you feel you need to use ADP's
instead of linked tables? For new projects using Access-to-SQL Server,
Microsoft recommends using ODBC links, although of course ADP's are
also supported. Here are some other resources to help you decide which
approach best suits your business needs.

--Mary

TechEd Online Panel (video):
Go to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for:
"Are we there yet? Successfully navigating the bumpy road from Access
to SQL Server"

Microsoft Access or SQL Server 2005: What's Right in Your
Organization?
http://www.microsoft.com/sql/solutions/migration/access/sql-or-access.mspx

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx

What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

FMS Upsizing Center
http://www.fmsinc.com/Consulting/sqlupsizedocs.aspx

Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446


On Fri, 14 Nov 2008 08:06:01 -0800, Dave
<Dave@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have inherited an access database that was converted from 2000 to 2007.
The
tables were then uploaded to SQL and linked. Can the .mdb file be
converted
to an .adp?


.

Relevant Pages
Loading