Hi All,
I have gone through few threads but nowhere i found the proper solution. Below is my requirement
1. Data is located in SQL server
2. From MS Access , i need to connect to sql server using sql server authentication and then query the tables
3. After that i need to create tables/views from the recordset through VBA
4. Am using form interface, button control for this
Could anyone please help me how to get through VBA?
I have tried option of connecting sql server through ODBC, but that is not what am looking for
I have gone through few threads but nowhere i found the proper solution. Below is my requirement
1. Data is located in SQL server
2. From MS Access , i need to connect to sql server using sql server authentication and then query the tables
3. After that i need to create tables/views from the recordset through VBA
4. Am using form interface, button control for this
Could anyone please help me how to get through VBA?
I have tried option of connecting sql server through ODBC, but that is not what am looking for
Last edited: