Advertisement

02.23.2008 at 08:46AM PST, ID: 23187182
[x]
Attachment Details

SQL Express vs. Access DB

Asked by SeanStrickland in SQL Server 2008, Microsoft Access Database, SQL Server 2005

Tags: Microsoft, SQL Server, Express Edition, Networked

I am building a database to work in a multi-user environment.  It's currently planned to use a MS Access database on a networked location.  

The database will be split with a front-end on user PCs, and a back-end on a network drive.  I understand that this means the client-side computers will be running the table queries/responses.

If I were to use a SQL Express Server instead, and place it on the network drive, would that make the front-end access forms, etc run faster and support a multi-user environment better and why?

Thanks,
SeanStart Free Trial
[+][-]02.23.2008 at 08:54AM PST, ID: 20965589

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.23.2008 at 09:16AM PST, ID: 20965677

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.23.2008 at 10:51AM PST, ID: 20966096

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.23.2008 at 11:08AM PST, ID: 20966185

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2008, Microsoft Access Database, SQL Server 2005
Tags: Microsoft, SQL Server, Express Edition, Networked
Sign Up Now!
Solution Provided By: chapmandew
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628