Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-28-2013, 12:12 PM   #1
DBinPhilly
Newly Registered User
 
Join Date: May 2013
Posts: 42
Thanks: 2
Thanked 1 Time in 1 Post
DBinPhilly is on a distinguished road
SQL Server Express Edition

In the distant past I've written .adp programs that linked to SQL Server 2000 and they were very nice but kinda hard to maintain from a distance.
Plus, at that time SQL Server 2000 required an actual File Server, such as Windows 2000 Server or 2003 Server, which was kinda pricy and was outside the budget of a large percentage of my customer base - thus necessitating maintaining separate versions of the same program - a real pain.

So my question: does SQL Server Express 2012 allow multiple users? It seems to me that earlier versions would only work on a local workstation.
Or must I resort to a full version of SQL Server if I have a multiple workstation environment (which I always do)?

DBinPhilly is offline   Reply With Quote
Old 05-28-2013, 02:06 PM   #2
Rx_
Nothing In Moderation
 
Rx_'s Avatar
 
Join Date: Oct 2009
Location: Denver, Colorado
Posts: 2,803
Thanks: 636
Thanked 337 Times in 307 Posts
Rx_ has a spectacular aura about Rx_ has a spectacular aura about Rx_ has a spectacular aura about
Re: SQL Server Express Edition

http://databases.about.com/od/sqlser...ss-Edition.htm
Unlike its predecessor, MSDE, it lacks a concurrent workload-governor to "limit performance if the database engine receives more work than is typical of a small number of users.

What I have been looking for: Microsoft came around to show off the new MS Access.
I asked them about the portable PC configuration. They told me it has the multiple OS via Virtual Machine. They use a Server for SQL Server, Web server, and (then Windows 7). It was running really well with an i5 3rd Gen Pentium.
Despite asking for the requirements and step-by-step to my MAPS group, I got nothing for you. At least yet.
__________________
Were you lucky enough to get an answer? Please mark your question as [SOLVED] The original poster can go to Thread Tools to mark it as Solved.

Quotation Thomas Jefferson: "Peace is that brief glorious moment in history when everybody stands around reloading."

There are 2 Kinds of Countries on this Planet
1. Those that use the Metric System
2. Those that had a man walk on the moon

Denver, Colorado - The "Mile High City" - non-metric!
Rx_ is offline   Reply With Quote
Old 05-28-2013, 02:06 PM   #3
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,656
Thanks: 98
Thanked 1,500 Times in 1,415 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: SQL Server Express Edition

It doesn't require a server OS and it can be connected to from other workstations.

AFAIK This has always been the case with Express (or MSDE as it used to be called) and the full version.

The limitations with Express are 10GB database and the use of 1 GB RAM and and single processor.

Galaxiom 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 '05 on top of SQL Server '08 running as mirror? madEG SQL Server 2 11-18-2010 02:59 PM
SQL Server 2008 Express Edition on Vista Rockape SQL Server 10 10-16-2010 07:56 AM
Database diagrams Visual basic 2008 Express Edition beeky VB.NET 0 03-11-2010 02:54 AM
SQL Server 2005 Workgroup Edition AnnPhil SQL Server 1 12-18-2006 03:37 PM
Sql Server 2005 Express Edition Support Multiple User jaydwest SQL Server 1 11-28-2006 09:03 AM




All times are GMT -8. The time now is 09:14 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