I'm doing an application and when I was programming the VBA code to connect to Access Database what was my astonishment gave the error:
"Microsoft Visual Basic Error 3706"
The connection line is:
.ConnectionString = "Data Source=" & ThisWorkbook.Path & "\BD_Loja1.accdb"
Can anyone help me with how to resolve this error?
It's probably a problem with your Provider ... Give more (much more) information about the code whenever you post something on the stack so you can help us help you.
Find out what Provider should be used with the type of bank and version of the access you are using. Below is an example and suggestion of modifying the code (remembering that you should research the ideal provider for your case and add this reference to the project)
strProvider = "Provider= Microsoft.Jet.OLEDB.3.51;"
strDataSource = ThisWorkbook.Path
strDataBaseName = "\BD_Loja1.accdb;"