Does Microsoft recommend databases or projects to connect to SQL s

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.
 
M

Mark Andrews

Try and use pass-thru queries vs. linked tables and regular queries where
possible.
That way the logic runs on the sql server side.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
SQL upsize 2 databases 2
Unable to make design changes in .adp connected to SQL server 2008 1
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Access 2007 Project Can't connect to SQL Server 2005 on my machine 2
Looking for experiences using .adp projects over SQL Server 2005 3
32 bit access application and 64 bit SQL 2008 2
Use of Virtual Machine 4

Top