ADP with 64 Bit SQL 2008

  • Thread starter Thread starter SimeonD
  • Start date Start date
S

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
 
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)
 
On Thu, 16 Apr 2009 12:59:22 -0400, "Sylvain Lafontaine"

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

-Tom.
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?
 
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).
 
Back
Top