ADP with 64 Bit SQL 2008



Currently have Access 2003 ADP, linked to SQL 2000 on a Windows 2003 server.
The server is being changed to Windows 2008 - 64 version.
Likewise, the SQL is being change to SQL 2008 - 64 bit version.

I realise I will have to upgrade the front end to Office 2007. But will even
that work with the 64 bit version?


Sylvain Lafontaine

If you don't do design changes to your database using Access, then you can
keep Access 2003; you don't have to upgrade to A2007 to update the data.
BTW, I don't have a copy of A2007 at hand at this moment but I think that
even with A2007, you can't make design changes to a database hosted on
SQL-Server 2008 (to be verified!).

Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server

Tom van Stiphout

On Thu, 16 Apr 2009 12:59:22 -0400, "Sylvain Lafontaine"

Unless you run passthrough queries like "ALTER TABLE ..."

Microsoft Access MVP


Thats ok, I knew you couldn't do the design changes with any Access version.
I didn't know that Access 2003 would work with SQL 2008. Thats good news.

What about the SQL 2008 64 bit version though?

Paul Shapiro

For connecting to data, there's no difference between SQL 32 and 64. If you
have connection problems, use the SQL Server Configuration Manager to verify
32-bit client connections are enabled with the necessary protocol(s).

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