isladogs
Access MVP / VIP
- Local time
- Today, 01:39
- Joined
- Jan 14, 2017
- Messages
- 19,312
I've just had a look at the list of ODBC data sources on 2 Win 10 machines with Access 2010:
a) a tablet which doesn't have SQL Server
b) a workstation which also has SSMS 2014
The tablet has a list of basic drivers for Access/SQL Server/Excel/Oracle/Paradox/Text which is what Pat was referring to.
These are installed with Access (or perhaps by Windows as Galxiom suggests)
The workstation has all the above items plus three more for SQL Server (highlighted).
As I've never added any of these manually, these must have been added when SSMS was installed (as I originally suggested back in post #8)
The following shows the SQL Server items from my list of services
Looking again at my example connection string from post #8 may indicate I'm only using the basic SQL Server driver.
Whatever the reason, all my apps with SQL Server BE files always work 'out of the box' with no additional configuration on each workstation
As a side note, can anyone tell me what 'Treiber' stands for in the list of ODBC sources
a) a tablet which doesn't have SQL Server
b) a workstation which also has SSMS 2014
The tablet has a list of basic drivers for Access/SQL Server/Excel/Oracle/Paradox/Text which is what Pat was referring to.
These are installed with Access (or perhaps by Windows as Galxiom suggests)
The workstation has all the above items plus three more for SQL Server (highlighted).
As I've never added any of these manually, these must have been added when SSMS was installed (as I originally suggested back in post #8)
The following shows the SQL Server items from my list of services
Looking again at my example connection string from post #8 may indicate I'm only using the basic SQL Server driver.
Whatever the reason, all my apps with SQL Server BE files always work 'out of the box' with no additional configuration on each workstation
As a side note, can anyone tell me what 'Treiber' stands for in the list of ODBC sources
Attachments
Last edited: