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"

This works: setting Provider to sqloledb and Data Source to point to the server:
    strConnection = "Provider=sqloledb;Data Source=server4;" & _
                "Integrated Security=SSPI;Initial Catalog=CustomerServiceSQL"