Steve Erbach
erbachs at gmail.com
Mon Jan 30 06:53:16 CST 2006
Dear Group, I read a recent SQL Server Central article by a fellow named Andy Warren that dealt with connecting to a SQL Server database using an Access MDB/ODBC connection. The article very nicely laid out the step-by-step process -- with screen shots -- to accomplish this. What made me curious about the article was that the author never mentioned ADP's. So I joined the discussion forum for this topic and read a number of interesting replies pro and con for MDBs vs. ADPs, some that I'm unable, from only my own experience, to evaluate. Here's one of them. The forum member started his message by saying that the article was good. He went on to say: ~~~~~~~~~~~~~~~~~~~~~~~~ "Two problems I've come across: "1) Nice three table view with calculated fields fully updatable in SQL server - lots of lovely triggers. Put it in an adp - not a chance. Put it in an mdb with the primary key set, fully updatable. Hmm! "2) Same view, all the base tables have audit triggers to check who changes important fields. T SQL is based on "IF UPDATE(fieldname) write to audit table "This works fine with T SQL, but use Access and every field is marked as dirty and you get all the relevant fields written to the audit table. I've had to resort to "IF (SELECT fieldname from inserted) != (SELECT fieldname from deleted) "I'd love to use a project if only it worked" ~~~~~~~~~~~~~~~~~~~~~~~~ Can anyone comment on this? Also, the author chimed in saying that he would do a followup article in the same vein using ADP's. He also said: "I tend to use the mdb over the adp format, just from habit as much as anything. I could entirely be wrong, but doesnt using the ADP format remove the use of module code? It does expose procs and triggers, which the mdb's do not." I honestly have only used ADP's to allow easier access to table contents and for making simple data entry forms...no heavy-lifting code at all. He can't be correctly, surely, in saying that ADP's "remove the use of module code," can he? Regards, Steve Erbach Scientific Marketing Neenah, WI www.swerbach.com Security Page: www.swerbach.com/security http://TheTownCrank.blogspot.com