ADP with 64 Bit SQL 2008

[SimeonD]

Hi
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?

Thanks
Simon

 

[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
(French)

 

[Tom van Stiphout]

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

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

-Tom.
Microsoft Access MVP

 

[SimeonD]

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