> If you install MSSQL7 on the machine you will need to get
> that latest MDAC drivers from MS to use Access. Something
> in the MDAC drivers shipped with MSSQL7 breaks Access97
> (and likely Access2000 too). You get all kinds of odd errors
> especially if you are using SQL concatenation functions.
You'll want to install the latest MDAC in any case. SQL 7 came with MDAC
2.0, which is full of bugs. You should at least upgrade to MDAC
2.1.2.4202.3, if not 2.5.
> Also I don't believe the MDAC drivers that shipped with 4.0x supported
> Access2k but I could be wrong on this.
I think that CF 4.0 came with MDAC 2.0.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
