Does Microsoft recommend databases or projects to connect to SQL s

  • Thread starter Thread starter NancyM
  • Start date Start date
N

NancyM

We are using Access 2007 to connect to both SQL server 2000 and SQL server
2005 databases. I am developoing a new project. Should it be an adp or an
accdb? Does Microsoft still recommend an Access project connected to the SQL
server database or are nthey moving back to mdbs and ODBC linking to SQL
server?
Thank you.
 
Try and use pass-thru queries vs. linked tables and regular queries where
possible.
That way the logic runs on the sql server side.
 
Back
Top