SQL Server 32 bit vs 64 (1 Viewer)

FuzMic

DataBase Tinker
Local time
Today, 20:31
Joined
Sep 13, 2006
Messages
719
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
Today, 23:31
Joined
Jan 20, 2009
Messages
12,849
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, 20:31
Joined
Sep 13, 2006
Messages
719
Thanks bro, so the trick is the ODBC
 

NauticalGent

Ignore List Poster Boy
Local time
Today, 08:31
Joined
Apr 27, 2015
Messages
6,286
Once you get into the Management Studio you won't want to write queries in Access any more.
Too true. I am just know getting into it, but so far the experience has been great
 

FuzMic

DataBase Tinker
Local time
Today, 20:31
Joined
Sep 13, 2006
Messages
719
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

Top Bottom