SQL Server 32 bit vs 64 (1 Viewer)

FuzMic

DataBase Tinker
Local time
Today, 21:10
Joined
Sep 13, 2006
Messages
678
Hi guys

First of all, the forum new looks is very good & trendy. Congratulations to the Administators for the upgrade.

I am contemplating to install SQL Server Express 2008 R2 to try my hand on using its database. As my favourite is still the older versions of msAccess eg 2003, which version of SQLSrv should i instal, 32bit or 64bit. If i do install a 64 bit version, i understand it can still create database of 32 bit which can then be read by the 32bit Access. Is my thoughts correct? Any advices much appreciated.
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 00:10
Joined
Jan 20, 2009
Messages
11,871
Use whatever version matches your operating system. The ODBC translates the SQL Server data for Access.

But why limit yourself to 2008? 2016 has some really great enhancements.

Once you get into the Management Studio you won't want to write queries in Access any more.
 

FuzMic

DataBase Tinker
Local time
Today, 21:10
Joined
Sep 13, 2006
Messages
678
Thanks bro, so the trick is the ODBC
 

FuzMic

DataBase Tinker
Local time
Today, 21:10
Joined
Sep 13, 2006
Messages
678
Sad to say I am using win7 so I have stick to v2008, apparently v2012 have issues with win 7
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom