Access as a front-end to SQL Server - ADO vs DAO?

Posted by webworm on Stack Overflow See other posts from Stack Overflow or by webworm
Published on 2010-06-11T20:20:13Z Indexed on 2010/06/11 20:22 UTC
Read the original article Hit count: 202

Filed under:
|
|
|

I have a project that will be using Access 2003 as the font-end and the data being stored in SQL Server. Access will connect to SQL Server via linked tables with all the database logic (stored procedures, views) within SQL Server.

Given this setup, would it be better to use ADO or DAO within Access? Is it just a matter of preference or is one more suited to Access as a font-end and SQL Server as the data store? Especially when using linked tables. Thanks.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about ms-access