ricardo1023
Programmer
I would like to get live data from our SQL server. I know that we can use ODBC for this but I would like to know if that is the recomended way to connect both databases these days.
Thank you
Thank you
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is ODBC The Only Way To Get Data Data From SQL Into Access Directly?
- Thread starter ricardo1023
- Start date
- Status
It's the easiest way, since you can use linked tables.
You can connect to SQL Server directly with ADO, but you have to write code for that. Without linked tables you would not be able to use data binding by simply setting properties of the forms and controls (you can write code to open an ADO recordset and attach it to the form or control).
I usually use linked tables for the stuff where it is fast enough, and use ADO for more advanced stuff such as searching so that I can use stored procedures, etc.
Joe Schwarz
Custom Software Developer
You can connect to SQL Server directly with ADO, but you have to write code for that. Without linked tables you would not be able to use data binding by simply setting properties of the forms and controls (you can write code to open an ADO recordset and attach it to the form or control).
I usually use linked tables for the stuff where it is fast enough, and use ADO for more advanced stuff such as searching so that I can use stored procedures, etc.
Joe Schwarz
Custom Software Developer
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question