473,326 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access vs. SQL backend?

General question for experienced ASP developers...

I am developing a web application for a small business. The primary use of the web application will be for clients to log on and retrieve information about thier accounts. Essentially just retrieving various queries from the database. I am much more familiar with Access than SQL and am wondering if I can get away with using that as my backend db. I cant really imagine a scenario (at least at this point in time) in which there would be more than 3 or 4 concurrent users at one time.

Any advice? Maybe it's time I get up to speed on SQL Server

Thanks

Mike
Nov 18 '05 #1
3 1119
MOST definately go to SQL server. I, too, had to make the jump about two
years ago and am very glad that I did.

Access is a nice desktop database engine, but anything that you (or someone
else) really cares about should be done on SQL server.

Steve
"Mike" <an*******@discussions.microsoft.com> wrote in message
news:5D**********************************@microsof t.com...
General question for experienced ASP developers....

I am developing a web application for a small business. The primary use of the web application will be for clients to log on and retrieve information
about thier accounts. Essentially just retrieving various queries from the
database. I am much more familiar with Access than SQL and am wondering if
I can get away with using that as my backend db. I cant really imagine a
scenario (at least at this point in time) in which there would be more than
3 or 4 concurrent users at one time.
Any advice? Maybe it's time I get up to speed on SQL Server?

Thanks,

Mike

Nov 18 '05 #2
Just a few concurrent users and mostly SELECT queries should be fine for
using Access (Jet). On the other hand, if you are writing the application
from scratch and are using the database purely for data storage and
retrieval and not using Access desktop features like forms, reports, macros,
etc. then use SQL Server.

Even better, for starters, use MSDE, the desktop version of SQL Server. I'm
assuming you already know how to construct a database schema and write SQL
queries, so there is not a whole lot to learn right off the bat with SQL
Server. (Writing stored procedures and db admin is another story and
something that can be learned later)

I'd recommend using MSDE or SQL Server.

Good luck.

--
Peter O'Reilly
"Mike" <an*******@discussions.microsoft.com> wrote in message
news:5D**********************************@microsof t.com...
General question for experienced ASP developers....

I am developing a web application for a small business. The primary use of the web application will be for clients to log on and retrieve information
about thier accounts. Essentially just retrieving various queries from the
database. I am much more familiar with Access than SQL and am wondering if
I can get away with using that as my backend db. I cant really imagine a
scenario (at least at this point in time) in which there would be more than
3 or 4 concurrent users at one time.
Any advice? Maybe it's time I get up to speed on SQL Server?

Thanks,

Mike

Nov 18 '05 #3
Thank-you. That was the info I was looking for!
Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jason Gyetko | last post by:
I have a software application with an Access front end and an Access backend to house the data. Recently I converted the backend to MySQL. The Access frontend works fine connecting to the MySQL...
63
by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy...
32
by: Mike MacSween | last post by:
Further to 'Security - more complex than I thought' Has anybody ever seen any studies? Or anecdotal evidence? Done any studies themselves? Done any lab testing - you know - 10 users asked to get...
29
by: Mark B | last post by:
We have an Access app (quite big) at www.orbisoft.com/download. We have had requests by potential users to have it converted to an SQL version for them since there corporate policy excludes them...
7
by: JMCN | last post by:
Is this possible to have the 97 users with 97 front end, 2000 users with 2000 front end, 2002 users with 2002 front end, and 2003 users with 2003 front end all linked up to an access 97 backend? ...
13
by: Manuel Lopez | last post by:
I have a puzzling form timer problem that I didn't experience prior to Access 2003 (though I'm not sure access 2003 is to blame). Here's the situation: a computer has two access 2003 databases on...
42
by: PC Datasheet | last post by:
I have zero experience with using a SQL database for a backend and Access for a frontend. I have some questions: 1. Does an SQL database have tables? 2. How does Access connect to the data in...
4
by: ThePhenix | last post by:
Hi everybody, I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend. I finished the conversion today (as quite a lot of the...
64
by: John | last post by:
Hello there, Im cursing my place of employment...and its taken me a month to realise it... The scenario: Ive just stepped into a role to migrate an access database to VB.Net. The access...
10
by: Les Desser | last post by:
In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Thank you for that. It was very...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.