adp general question

[JohnE]

Hello. This is mainly a general question regarding doing an adp project
rather then the mdb. The boss would like to use the sql2005/express for the
tables and A2k for the front end. I rarely have done a project so I am
wondering if anyone has any suggestions for a good reference book on the
creating projects? Or any other words of wisdom or encouragement?
Thanks to those who respond.
*** John

 

[AkAlan]

Microsoft Access Developers Guide to SQL Server by Chipman and Baron has
helped me a lot.

I am in the middle of converting all my mdbs to
ADPs and am having a lot of fun, mostly. Give yourself a lot of time plaing
around with it. I am constantly under the gun to finish databases and would
have like a little more time. Well worth the effort. here are some of my
thoughts:

use ole db to connect as opposed to odbc
use functions to retrieve and update data when multiple parameters are
concerned. The book says functions are not updateable but they are and it's a
lot easier to handel multiple parameters than stored procedures, although
there are a couple of tricks you ned to know first. post back with an email
address and I'll send you more info on that.

 

[Albert D.Kallal]

The general consensuses and view is to use linked tables to sql server, and
NOT use a adp proejct.

If you are staring from scratch, (or don't have much code in a an existing
application), then a ADP is a good choice.

However, if you have a complex application, or want to have things like
local tables etc, then a very large portion of developers will actually
suggest to use linked tables to sql server. And, in fact, with sql server
express, ADP proejcts are limited in use...

So, you might want to consider developing a mdb and use linked tables to sql
server. The best road much depends on how much existing application stuff
you need to transfer to sql server.

 

[Sylvain Lafontaine]

The functions where not updateable with ADP 2000 (or A2K) if I remember
correctly; however this problem has been corrected in the 2002 version.