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

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.

Access Performance Vs .Net Performance

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Access Performance Vs .Net Performance

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us