Solved

MSAccess frontend and SQL  backend

Posted on 2014-03-10
9
637 Views
Last Modified: 2014-03-25
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
Comment
Question by:PipMic
  • 2
  • 2
  • 2
  • +2
9 Comments
 
LVL 8

Assisted Solution

by:jpgobert
jpgobert earned 70 total points
ID: 39918748
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
 
LVL 84
ID: 39919200
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
 
LVL 35

Expert Comment

by:PatHartman
ID: 39919515
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 41

Expert Comment

by:pcelba
ID: 39920035
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
 

Author Comment

by:PipMic
ID: 39921760
Thanks guys,

But do i have to install .net software?
0
 
LVL 41

Assisted Solution

by:pcelba
pcelba earned 50 total points
ID: 39921775
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
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 50 total points
ID: 39922396
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
 

Author Closing Comment

by:PipMic
ID: 39952935
Good combination of info.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delete QueryDef IF it Exists: Access VBA 5 32
Dlookup MSACCESS 5 24
MS Access Delete All Excel sheets 1 7
Creating Functions in phpMyAdmin 8 12
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Read about achieving the basic levels of HRIS security in the workplace.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question