Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-28-2016, 04:04 PM   #1
mjdemaris
Working on it...
 
Join Date: Jul 2015
Location: Washington State, USA
Posts: 338
Thanks: 72
Thanked 7 Times in 7 Posts
mjdemaris is on a distinguished road
New to SQL Server Express

Hey everyone,

just got Express 2014 installed with the advanced options, except the LocalDb. I have no real idea of how to do much with it. I just figured out how to make tables, but not even sure that they are in the right tree in the Object Explorer.

I've been reading some articles here and there, but do you know of any good sites that offer beginner advice on creating tables, relationships, and adding data?

The end goal: to connect Access front end to SQL back end.

Thanks.

__________________
Life is not a problem to be solved, but a reality to experience.

Soren Kierkegaard
mjdemaris is offline   Reply With Quote
Old 07-28-2016, 04:41 PM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,515
Thanks: 40
Thanked 3,398 Times in 3,292 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: New to SQL Server Express

Unless things have changed, Sql server does not have the helpful gui's available in access, although tables can be created in much the same way. The rest you do in SQL - this link provides examples for SQL server, access and others

http://www.w3schools.com/sql/sql_foreignkey.asp

with regards connection, the usual way is via ODBC to create linked tables to either the tables themselves or views (basically a select query created in SQL server) and/or using stored procedures which is very roughly the equivalent of having vba code run a number of queries. Probably best to join a sql server forum for questions on these.

performance - sql server uses up to 4 cores of memory so can work faster, express however only uses 1 core, same as Access so you will probably see little performance benefit - but do as much data processing within sql server to maximise this benefit. This in turn requires a more disciplined approach to processing data and the way your forms work.

Security - much better than access, but also more work to maintain
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
mjdemaris (07-28-2016)
Old 07-28-2016, 05:10 PM   #3
mjdemaris
Working on it...
 
Join Date: Jul 2015
Location: Washington State, USA
Posts: 338
Thanks: 72
Thanked 7 Times in 7 Posts
mjdemaris is on a distinguished road
Re: New to SQL Server Express

Would it be possible to access this database via browser, and perhaps bypass access altogether?

__________________
Life is not a problem to be solved, but a reality to experience.

Soren Kierkegaard
mjdemaris is offline   Reply With Quote
Old 07-28-2016, 05:38 PM   #4
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,515
Thanks: 40
Thanked 3,398 Times in 3,292 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: New to SQL Server Express

of course - use html5, java, whatever. Or look at visual studio express if you want to build using a gui similar to the access form builder - but be aware it is a very steep learning curve - controls are very basic, you have to add your own functionality etc. - but then you are not restricted to the functionality provided by access.

Biggest issues I've found is a) no concept of subforms and b) no concept of continuous forms although you can build your own from various components and c) no reporting function as such - use something like crystal reports.

Again, not much 'easily digestible' online help and requires a different way of thinking - much more object orientated and the environment changes rapidly. Threads less than 12 months old saying 'do it like this' may already be out of date. Avoid javascript - ignored in Microsoft Edge and about to be in chrome.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 01-09-2019, 01:40 PM   #5
Mr. SLP
Newly Registered User
 
Join Date: Dec 2017
Posts: 56
Thanks: 14
Thanked 1 Time in 1 Post
Mr. SLP is on a distinguished road
New to SQL Server Express

So, stupid question, tech services reminded me of SQL Express and I’m thinking of transitioning over to it. However, they were trying to tell me that the basic setup would be the same as what I have now, BE file on a storage server and FE on each individual computer, and that it wouldn’t need any computer running SQL express all the time to host it. Is this right? I would think I would need a computer running the server program in addition to basically having a NAS that the data is saved to.

Edit: Oops. Meant to post this in another thread but got distracted before switching over and thought I already had.

Sent from my iPhone using Tapatalk
Mr. SLP is offline   Reply With Quote
Old 01-09-2019, 01:56 PM   #6
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,320
Thanks: 10
Thanked 3,920 Times in 3,861 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: New to SQL Server Express

Unless something has changed, I disagree. The express version is basically a limited version of SQL Server; it still has to be installed and running on a computer to be able to access the data. A NAS wouldn't be necessary, but it could be where the data files are stored (in my installs they are on the server running the program).
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 01-10-2019, 03:07 PM   #7
kevlray
Newly Registered User
 
Join Date: Apr 2010
Location: Central California
Posts: 593
Thanks: 9
Thanked 50 Times in 48 Posts
kevlray will become famous soon enough
Re: New to SQL Server Express

So I saw this question and looked up SQL Express. It turns out it will use 4 cores and has a max DB size of 10 GB. Thus maybe some performance gain over Access. I do not recall how big an Access DB can be. I have run SQL Express on my computer in the past. From what I recall it was a pretty easy setup.

kevlray is offline   Reply With Quote
Old 01-10-2019, 03:18 PM   #8
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,320
Thanks: 10
Thanked 3,920 Times in 3,861 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: New to SQL Server Express

An Access db can be 2GB. I thought Express only used 1 core, but I see that's changed. Or I was wrong.

__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Express Edition DBinPhilly General 2 05-28-2013 02:06 PM
SQL Express vs SQL Server Thales750 SQL Server 1 06-06-2011 12:36 PM
SQL Server Express '05 on top of SQL Server '08 running as mirror? madEG SQL Server 2 11-18-2010 02:59 PM
SQL Server Express...where to start CEH SQL Server 19 08-28-2008 09:53 PM
Upgrading to sql server express giovi2002 SQL Server 5 04-26-2006 08:09 AM




All times are GMT -8. The time now is 05:07 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World