Question 5 of 20 5.0 Points Which of the following would create a connection str

Question

Question 5 of 20 5.0 Points Which of the following would create a connection string to an Access file named "customers.accdb" given that mypath - ThisWorkbook Path. mypath&"7customers.accdb,"mypath & "Icustomers.accdb O A Set strConnect: Provider-Microsoft Ace OLEDB 120; Data Source:" &- mypath & Icustomers.accdb O B strConnect: Provider-Microsoft Ace OLEDB 12 0: Data Bases" & mypath &"/customers.accdb, 0 ChstrHook: Provider-Microsoft Ace OLEDB 120, Data Source:" &- mypath & Icustomers. accdb D. None of the above Reset Selection

Explanation / Answer

Answer:

B. strConnect ='Provider'=MicrosoftAce.OLEDB.12.0;Data Base='&_mypath & */Customer.acccb'

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.