• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 667
  • Last Modified:

MSAccess frontend and SQL backend

Hi all,

I would like to learn more about using SQL as my backend. I am quite sure this is something very normal for databases with a huge numbert of records and it is somethin I am keen to experiment with.

I should therefore be grateful if someone would point me in the right direction because every time I try to download the trial free version it asks me to select from a raft of components which I have no idea of.

Also, I am using Win7 as my OS on a 64 bit laptop.

Comments appreciated.... thanks
0
PipMic
Asked:
PipMic
  • 2
  • 2
  • 2
  • +2
3 Solutions
 
jpgobertCommented:
Why not start with SQL Express if you're just trying to learn?  You can download SQL Server 2012 Express from here:  MS Download Center - SQL Server 2012 Express

When you click on Download you'll have a list of downloads to choose from.  Just choose the first one, "SQLEXPR_x64ENU.exe" and also "SQLManagementStudio_x64_ENU.exe".

The first is the actual installer for SQL Server 2012 Express.  The second is the installer for SQL Management Studio.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Essentially all you need with SQL Server and SSMS from the links above.

Once you have those, you can open SSMS and work with the databases - you can add a New database, modify an Existing one, etc etc. SSMS is kind of like a cross between the Access Table and Query designers, with lots of other stuff built in.

You'd then link your tables on the server back to your database in Access, and you should be off to the races.

There are some differences - for example, SQL Server does not have a Boolean field, and instead uses the Bit datatype for that. Often your Access database will have troubles with this, so you've got to do a bit of research.

MSFT offers a SQL Server Migration Assistant that can help you move your data up to SQL:

http://www.microsoft.com/en-us/download/details.aspx?id=28763

While Access includes the "upsizing wizard", in general you'll get better results using the SSMA.

Here's some other resources that may help with your conversions:

http://www.fmsinc.com/tpapers/index.html#SQLPapers
http://www.jstreettech.com/downloads.aspx - the Best of Both Worlds
0
 
PatHartmanCommented:
When you install SQL Server Express for testing, you can safely take the defaults.  If this is something you will use for a production application, you are better off paying someone to set it up to your specifications.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
pcelbaCommented:
Wow EE is censored...

Even my paragraph saying "You may link SQL Server tables from MS Access and work with then as if they were Access tables" was removed...

Serious admin would keep the track of this change in the question itself but that's not EE case... Where is the (EE) World going to?


Here is the post from admin:
I've removed your comment in the thread above, since it was little more than links to competing sites.

Please see this Help article:

http://support.experts-exchange.com/customer/portal/articles/1162518

Essentially you're expected to provide full details of your suggested solution directly in the question thread. The use of links should be used to support your own suggestions, not to directly answer the question.

SouthMod
EE Moderator
SouthMod@e-e.com
0
 
PipMicAuthor Commented:
Thanks guys,

But do i have to install .net software?
0
 
pcelbaCommented:
No, not at all.

Install just the SQL Server Express + MS SQL Management Studio Express.

SQL Server Express is the data engine (running as a Windows Service) and Management Studio allows to manage the data at administrative level (user rights, database setup and maintenance, query tools etc.)

After you'll do the SQL setup then you may use just MS Access to handle SQL data as linked tables.

Basic knowledge of SQL language is essential to do this task.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
But do i have to install .net software?
You do need the correct .NET frameworks installed, but in almost every case those are already present on the machine.
0
 
PipMicAuthor Commented:
Good combination of info.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now