Access Performance Vs .Net Performance

Question

1.00/5 (2 votes)

See more:

my question is raised to the people who have worked in Access Programing and moved then to .Net FrameWork(C# visual Studio)

if we have an application that needs insert update and delete operations
what will the advantages that it have if we deploy it in C#.net Vs Access
or there is no difference ?
i think the speed is the difference
so what are c#.net advantages vs Access ?

Posted 19-Nov-14 20:54pm

oula alsheikh

Add a Solution

Comments

DamithSL 20-Nov-14 3:24am

Short answer is "It Depends"
You are comparing two different things (desktop database tool vs framework and the set of tools)
According to your experience what is good for your application?
have you done same testing on performance on both types of applications?

oula alsheikh 20-Nov-14 4:42am

iam working in a company that depends on access program
and now we want to deploy this program in C#.net
i have not done testing so before testing i want your experience
because i want to convince them by .net i think it is quicker?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

BillWoodruff · Answer 1 · 2014-11-20T01:41:00

Solution 2

Note that I do not use MS Access myself, and my only experience with it was doing some interop with Excel many years ago.

In terms of deployment: MS does provide free MS Access run-time for use (no purchase required): ^], [^].

In terms of speed: depends on the structure of the database, the use-cases, etc.

I suggest you read this comparison of Access and SQL: [^].

Posted 20-Nov-14 1:41am

BillWoodruff

Comments

oula alsheikh 24-Nov-14 2:31am

i want to concentrate on speed and reliability can you help me please
according to many essays access cant handle more than 10 users and it has a big probability to be in a database crash and network bottleneck

OriginalGriff · Answer 2 · 2014-11-19T22:10:00

Solution 1

The major difference is that if you deploy an Access based solution, then the user has to have Access installed on his computer in order to use it. This may well not be the case, and can be expensive for the user to fix...
A C# / .NET solution on the other hand should include all the relevant files in the installation package, and so shouldn't rely on the user having software previously installed.

Posted 19-Nov-14 22:10pm

OriginalGriff

Comments

BillWoodruff 20-Nov-14 7:37am

While I wouldn't go anywhere near MS Access, meselves, I am aware that the Access Runtime is free, and available, and does allow CRUD.