Is Access Program frontend SQL Server backend appropriate?

Asked By josiemelissaa 10 points N/A Posted 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?

• Status: Open
• Question Views: 682
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Williams Todd 0 points N/A #196306

Is Access Program frontend SQL Server backend appropriate?

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.

About Williams Todd

Questions
4

Answers
143

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 02/11/2013
• Question Category: MS SQL Server