Dear friends,
I created a database and the tables in SQL Server 2012 to make them linked table in my Front End Access 2016. My application will be used in multi user environment.
I have VBA codes and macros in my Front End Access which controls the forms and bring data from other applications to form fields as well. My queries will remain also in my Front End MS Access.
At this point, after linking the table I have following questions below.
1- Where should I establish relationships between those two?
In MS Access or in SQL Server, or in both the same relationships?
2- I read something and took some main information about DAO and ADO connection types. However I did not understand which connection type I did? How can I understand it? Because I did not choose anything about ADO or DAO while doing linking table process between MS access and SQL Server?
3- After I linked the table, the linking address is like below;
ODBC;DSN=Nametext;Trusted_Connection = YES;APP = Microsoft Office .............................
However On the internet examples, I also saw the linking address like below
ODBC;DRIVER=SQL Server;SERVER=Localhost;Trusted_Connection = YES;APP = Microsoft Office .............................
So what is the difference? and Could we say one of them is proper way and the other not?
4- During the external database (SQL Server) table linking process to MS Access, I needed to choose some option like below to find my MS Access. And there were various options in the list like below, which one shoul be choosen? I choose the second one. But I have no idea what would be difference if I choosed others.
* Microsoft Access Jet Engine
* Microsoft Access Database Engine
* Microfoft Access OLEDB
5- I have some options while creating the SQL Server connection with my FE which are like below; which one should be choosen here? what is the difference?
SQL Server
SQL Server Native Client 11.0
Many thanks in advance.