Is Access Program frontend SQL Server backend appropriate?

Asked By 10 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #196306

Is Access Program frontend SQL Server backend appropriate?

qa-featured

Hello,

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.

Login/Register to Answer

Related Questions