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)


"SimeonD" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

On Thu, 16 Apr 2009 12:59:22 -0400, "Sylvain Lafontaine"
<(E-Mail Removed)> wrote:

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

-Tom.
Microsoft Access MVP


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

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?


"Sylvain Lafontaine" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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)
>
>
> "SimeonD" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>
>

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

"SimeonD" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>
>
> "Sylvain Lafontaine" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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)
>>
>>
>> "SimeonD" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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