Solved

Moving from Access to SQL Server Express 2005

Posted on 2007-03-19
2
202 Views
Last Modified: 2010-04-23
I have a VB.NET 2003 application which uses an Access database. I would like to upgrade it to use an SQL Server 2005 Express database because I've read that SQL Server Express will basically replace Access and make it obsolete. Firstly, is this true? Also, if I do this, will the client then need SQL Server Express 2005 installed on his computer to run my app? Will he have to have any knowledge of SQL Server to run my app? Will he have to attach the database file to SQL Server? Is there a way to automatically instal SQL Server Express 2005 (if he requires it) during installation of my application? Is it worth while to move from Access to SQL Server Express 2005?

The application is desktop based, but reads the database from the server across a LAN. Typical usage scenario is between 1 and 5 people.

Thanks
0
Comment
Question by:SETP
2 Comments
 
LVL 28

Accepted Solution

by:
iboutchkine earned 300 total points
ID: 18747490
SQL Server Express is not going to replace Access database. Do not worry. For 1-5 people use Accesss
0
 
LVL 27

Assisted Solution

by:planocz
planocz earned 200 total points
ID: 18748186
Hi SETP,
I personnally would go ahead for the full upgade of SQL2005. but, like iboutchkine said if you are going to have only a few people then access is good (microsoft said that Access is good for up to about 50 people). As far as working with SQL all you will have to do is change your connections and import your tables, etc. and you are ready to go with SQl2005.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Advice in Xamarin 21 79
Gridview selected row 9 45
Get Client IP on RDS - VB.NET 15 45
VB.Net/LINQ: ".Contains" condition not finding existing result in MSSQL 16 35
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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