Safe to use access DB for website ?

  • Thread starter Thread starter Phill
  • Start date Start date
P

Phill

I'm debating weather to use Access or SQL Server for a website. Can
Access safely allow multiple concurrent users or do I need to use SQL
Server?

I'd appreciate any info. Thanks.
 
DONOT USE ACCESS OR JET BASED ANYTHING for a website.

Have you seen MSDE? That's a free version of SQL Server (well stripped
down). It's fantastic really and much better than Access/Jet blah blah.

Even MySQL is better than Access, but MSDE is free and better IMHO. Also,
with 2005, you'll have SQL Server 2005 Express and thats pretty fantastic
(no 5 user throttling, though 42 process throttling or somethin' like that).

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik
 
Defenitely I'd go for SQL Server. MSDE it's a free desktop version of SQL
Server.
Functionality wise and user concurrency MSDE excels MSAccess.

for me, MSAccess is a toy system.

Manny.
 
SQL is the way to go. MS says that Access can support up to 255
simultaneous connections, but in reality it is much less than that.
 
Even though some Access lovers might say yes and tell you stories about X
number of concurrent issues, the simple answer is NO. You can tow a boat
with a Yugo but why? It's more headaches than it's worth and it won't do it
well and even if it works it won't last long. Backup and Restore are a
whole different issue. Need Point in time restores? Have fun trying it
with Access.

Sql Server is the way to go and MSDE is free.
 
I've seen it buckle under 5 people banging on it pretty well - and the
tables were tiny.
 
Yes, I have seen MSDE and the more I figure it out the more I like it.
It seems you are all in agreement that MSDE/SQL Server is way better
than Access.

I just wanted to make sure I wasn't doing overkill by using MSDE when
Access would have done the job just as well. But I think you've
convinced me to move away from Access.

One question about MSDE if I may:

I figured out how to setup a database locally using MSDE. I have an
sql script I run w/ osql.exe.

So say my server is in c:\SQLSERVER\SQL$MyDB\ (locally).

How do you go about uploading it to a hosting company? Can an MSDE DB
folder simply be uploaded? Do you have to find out the Sql Server name
on the hosting company and run an sql script against it to create your
DB on their instance of SQL Server?

I'm confused about how this process works. Its this that makes me
hesitant to use SQL server. I'm used to just uploading files. But
would love to use MSDE if I can figure out how to get the database
setup remotely.

If anyone can explain this to me I'd really appreciate it. And thanks
for all the input everyone.
 
Back
Top