There are numerous differences.  If you have an Access background I would recommend Alison Balter's "Mastering Access 2002 Enterprise Development".   The book is written from the Access perspective and a...

You may consider compiling the adp to an ade file in a shared network location.

Sorry, I don't have an answer.  You would have a better chance of getting an answer from a TSQL genuis by posting your question under TSQL.  Remove the references to...

If possible convert your query to a SQL view then link the view to Access.  Views perform better than queries.

Andy,

This is still a great article.  The ketchup tab is a almost no cost solution with great benefits to many users.  Not a sexy project to add to your resume...

Have you tried copying the mdb file and saving to another name?

If that does not work you may try importing to Access first.  It will list import errors in a table.

Sushila,

I can use that option on the wizard when DTS from SQL to SQL, but the option is grayed out on a DTS from Access to SQL.  Is there a...

You will not have the problem in an Access Data Project, (ADP).  This may not be a good solution if you have a lot of queries because you have to convert...