N/APosted on - 01/27/2013
I'm trying to create 32-bit app frontend for a SQL server back end so users can input necessary data.. Can I link Access to SQL Server via ADO? Is Access program frontend sql server back end appropriate so Access can use the internet?
Is Access Program frontend SQL Server backend appropriate?
To connect Access to SQL Server you can use two methods: ODBC or ADO. If you use ODBC to connect through Jet then it is recommended that you use DAO because ADO’s performance is poor. For example, using ADO and SQL Server Native Client will cause update failure to computed columns. The following site has some good examples.
I hope this is helpful.