Using Microsoft Access and ASP.Net

Can Microsoft Access be used in ASP.NET development?  What are the limitations?

Only admin will have read/write access.  All others will have read only access.

I want to create a small to medium size database.  No more than 3000 rows.
Ray TurnerSenior ConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Biggest limitation with JET/ACE is that there is no on-line backup nor DB maintenance (compacting).   DB must be off-line for both (you actually can copy a DB file while it's in use, but HIGHLY NOT RECOMMENDED).

Outside of that, it makes a better data store for a web site than most think.   The webserver is the only user directly touching the DB file and if the DB is on the server, it's a very stable situation.

 And 3,000 rows is not even medium, but rather quite small.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ray TurnerSenior ConsultantAuthor Commented:
Great!  Thanks.
Ray TurnerSenior ConsultantAuthor Commented:
One last question for my clarification.
If I use Access as the datastore will there be any limitations on the number of users that can hit the website?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
No and this is where everyone gets it wrong and assumes JET/ACE can't act as a data store for a web site.

What everyone forgets is that no matter how many users hit the site, it's the server software that is talking to the DB, not the users.

The main drawback though is the no on-line backup or maintenance.  Most web sites want to be up 24 x7.   But there are still times/places when using JET/ACE makes sense.

Those are starting to get few and far between with how far things like SQL Server has come, but there are still some.

Ray TurnerSenior ConsultantAuthor Commented:
Wonderful!  Thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.