I modified the strConnetion parameters for the ModDatabaseLogic module as follows. I know the connection to the SQL Server database is functioning because when I created the tables on the adp side the databse and tables appeared in the sql server. The File->Connection parameters show "server4" as the server name and "Mycustomerservicesql" as the database name. I also have verified the "Data Source" path parameter. Any ideas why it fails?
strConnection = "Provider=server4;Data Source=n:\it\data Integration Project\Access2003VBA\Chapter 13" & _
"Integrated Security=SSPI;Initial Catalog=MyCustomerServiceSQL"
This is what is given in the book on page 460 and in the sample code
strConnection = "Provider=sqloledb;Data Source=goz_tablet1100\sqldev;" & _
"Integrated Security=SSPI;Initial Catalog=CustomerServiceSQL"