Jul 2, 2007 #1 WBH1138 Programmer May 31, 2002 85 GB Hi I am writing a VB6 project(s) which will use ADO with Access 97, 2000 and 2007 databases. Can anyone tell me which Project References I need to set for each and what the connection strings should be please. Thanking you in advance Wayne
Hi I am writing a VB6 project(s) which will use ADO with Access 97, 2000 and 2007 databases. Can anyone tell me which Project References I need to set for each and what the connection strings should be please. Thanking you in advance Wayne
Jul 2, 2007 #2 SBerthold Programmer Sep 20, 2002 1,014 DE Download and install MZTools from http://www.mztools.com/index.htm Set reference to: "Microsoft ActivX Objects 2.x Library where 2.x is 2.5 or higher Use in MZTools, under menu Extras-MZTools-Other tools-ADO Connection string this tool to help you build the ADO Connection string. Upvote 0 Downvote
Download and install MZTools from http://www.mztools.com/index.htm Set reference to: "Microsoft ActivX Objects 2.x Library where 2.x is 2.5 or higher Use in MZTools, under menu Extras-MZTools-Other tools-ADO Connection string this tool to help you build the ADO Connection string.