473,698 Members | 2,304 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS Access Database right for us?

Hi -- we are a small manufacturing looking for a multi-user database to
take customer orders (nothing too complicated, with 3 users total). We
think we should be using Access, but are wondering what alternatives
there are. It has been recommended to us to use ASP.net and SQL
instead, with the reasoning that:

1) Access is likely to go obsolete at some point
2) It will be more stable

Does anybody have any thoughts on this?

Feb 17 '06 #1
7 2911
Allison,

Your situation sounds like an ideal task for Access. As for Access
being obsolete anytime soon I don't see that happening. Access can
handle 3 users no problem.

I would recommend that you get the Access database setup by someone
with some database experience as a poorly designed database regardless
of the application could have problems.

The ASP.net and SQL server options would require much more development
time and money.

Just my two cents...

Good luck,

-Joe

Feb 17 '06 #2
"Allison" <ma***********@ gmail.com> wrote in
news:11******** **************@ f14g2000cwb.goo glegroups.com:
It has been recommended to us to use ASP.net and SQL
instead, with the reasoning that:

1) Access is likely to go obsolete at some point
The person making the recommendations is clearly quite ignorant of
reality. Microsoft has already invested a huge amount of work in the
next version of Access, Access 12, which will be released as part of
the next MS Office suite, which I expect to be released along with
Windows Vista next year.

From the documentation that has been released about the beta version
of Access 12, it looks like a significant upgrade, though so far,
most of the changes seem to me to be in end-user features, rather
than in features for developers of applications, but the record on
all of this is incomplete (there's a blog devoted to Access 12 at:

http://blogs.msdn.com/access/default.aspx

and the discussion there has mostly been devoted to an overview and
the beginning of a detailed discussion of the new features, which so
far have just gotten through some parts of the revised UI).

It seems pretty clear to me that Access is going to be around for
the long haul, though it may be rather different in new versions.
But Windows Vista is itself going to be rather different from
earlier versions of Windows, so it would be odd not to expect Access
to evelve along with the new user interface features.
2) It will be more stable


Define "stable."

An ASP/SQL Server application will be much, much more expensive to
implement, less feature rich, and probably have slower performance
(because it takes more screens in a browser-based application to
replicate all the functionality that can be included in an Access
form). With 3 users and a properly functioning network, there should
be no difference whatsoever in stability.

But the real answer would be to compare the cost of an Access app
with the cost of an ASP/SQl Server app. I would expect a multiplier
of at least 5X for the browser-based app.

The only real advantage for the browser-based app is portability,
but that isn't much of an issue any longer, either, as Windows
Terminal Server makes it extremely easy to make an Access app
available to remote users with the installation of minimal client
software (Remote Desktop Connection is pre-installed on all WinXP
PCs, so for them, there's no client installation at all).

Do the numbers and if the quotes you get are actually honest, you'll
see that the Access app is clearly going to win on a cost/benefit
analysis. If the numbers are not as widespread as the 5X or more
I've suggested, then you're probalby comparing apples to oranges in
terms of functionality. One way to work that out is to give the
quotes to the competing developers, i.e., the ASP quote to the
Access developer and the Access quote to the ASP developer, and then
let them point out what's missing from the competing bid. This
process will probably be an eye-opener.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Feb 17 '06 #3
"To take customers orders?" Don't bother... buy a off-the-shelves
solutions as Quickbook.

"Allison" <ma***********@ gmail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
Hi -- we are a small manufacturing looking for a multi-user database to
take customer orders (nothing too complicated, with 3 users total). We
think we should be using Access, but are wondering what alternatives
there are. It has been recommended to us to use ASP.net and SQL
instead, with the reasoning that:

1) Access is likely to go obsolete at some point
2) It will be more stable

Does anybody have any thoughts on this?

Feb 18 '06 #4
"Allison" wrote
Hi -- we are a small manufacturing looking for
a multi-user database to take customer orders
(nothing too complicated, with 3 users total).
We think we should be using Access, but are
wondering what alternatives there are. It has
been recommended to us to use ASP.net and
SQL instead, with the reasoning that:

1) Access is likely to go obsolete at some point
All software will "go obsolete at some point". On the other hand, some
mainframe code that I wrote in the 1970s is still in use. Access is the
database component of Microsoft Office and (Microsoft isn't saying) the
concensus is that Microsoft Office has well over 90% market share. That
tells me that even if every other database in that marketplace _doubled_ its
market share, Microsoft would still have the vast majority. It is also a
concensus that Office is Microsoft's "cash cow". Companies in business to
make money, and Microsoft _is_, do not kill off their "cash cow" nor do they
allow it to "go obsolete" due to neglect.
2) It will be more stable
ASP.NET with SQL Server "more stable"? First, you can't reproduce with
ASP.NET the kind of rich-client front end that you can create with Access --
ASP.NET applications are used through a web browser and web browsers just
don't have that kind of user interface capability. And, even if you could,
it would take (pardon the technical terms) "oodles, gobs, and bushels" of
hand-coded HTML, VB.NET or C#, to do what a simple Access database would do.
(Get that, new, hand-coded, still have to be tested... Most of what you do
with Access is done for you _by_ Access, and much of that has ten years of
testing by millions of users behind it.) Too, it's my experience that
typical ASP, ASP.NET, classic VB, VB.NET, classic C, C++, C# developers
don't know very much about what a database really is, how to use a database,
etc., and you often end up with code that, politely put, "does not make the
best use of a database".

Could I venture a guess? I'd guess that the people giving you this
misleading advice are people who create ASP.NET applications for a living,
and, perhaps even, _sell_ licenses to SQL Server. If not, I'd guess it is
people who have already been misled by someone in those categories and are
passing on the bad advice they've received.

If your three users are on the same LAN, it would be sheer folly to invest
in writing a web-based application (as ASP.NET would be). It would be costly
(several times as costly as an Access database application), and, in fact,
probably not _nearly_ so stable.
Does anybody have any thoughts on this?


We hear/read this kind of thing, both first and second hand, in the
newsgroups every day. Often it even comes from people who either do, or
should, know better. It has been my pleasure to explain and demonstrate, in
person, to a number of people just how misleading it is. Most of those
people are now happily using an Access user interface to whatever database
engine they chose.

That is, with Access you aren't limited to the included Jet engine, nor the
free, included MSDE (a performance-limited version of Microsoft SQL Server),
but can use any ODBC-compliant database for your data store. And, believe
me, you stand a far better chance of successful use of MS SQL Server using
Access and MS SQL Server's ODBC driver than some non-database programmer's
ASP.NET application and Microsoft SQL Server by that non-database
programmer's newest generation of hand-coded data access.

On the other hand, Saintor makes a good point -- there are relatively
inexpensive "canned solutions" available. If you can find one that adapts
easily to your business model, or if you can adapt your business model to
the canned solution, that is likely to be a cost-effective solution in the
long run. On the other hand, people have been creating or hiring someone to
create "custom business solutions" for them since the earliest days of the
computer age, because they wanted something that supported the way they were
already successful at conducting their businesses.

Larry Linson
Microsoft Access MVP
Feb 18 '06 #5
If someone capable designs and creates the application it doesn't
matter what you use. If someone who is not capable designs and creates
the application it doesn't matter either. You already know someone
really out of his/her depth; he/she made the recommendation.

Buying something shrink-wrapped might be your best bet; but I find
things that begin with "Quick" slow, clumsy and limited. My opinion is
that they were invented for the use of Accountants who charge by the
hour to do data entry with them.

Feb 18 '06 #6
Thank you for your responses.

One of the reasons we don't go with a pre-packaged solution (i.e.,
Quickbooks Manufacturing) is that the company owner has specific
requirements for the database no solution we've encountered has been
able to accommodate. (We've had to buy and return Quickbooks
Manufacturing, as well as another similar type software.)

I guess another possiblity is to use Filemaker, but we live in a fairly
isolated community and are worried about the fact there would be
limited access to other Filemaker experts should the one we know
decides to leave, for whatever reason.

The other reason the programmer is recommending .ASP with SQL is
probably because one of our "wish list" (not essential) features is for
salespeople to access the database when they are out of the country.
(For light occasional usage, not heavy usage.) We would think there are
other third party solutions that can do this in conjunction with
Access, but maybe I am wrong. Anyone have comments on this?

Feb 20 '06 #7
When you introduce the internet usage then ASP with SQL makes much more
sense.

Feb 21 '06 #8

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

Similar topics

17
2895
by: chicha | last post by:
Hey people, I have to convert MS Access 2000 database into mysql database, the whole thing being part of this project I'm doing for one of my faculty classes. My professor somehow presumed I knew db's and gave me long list of things to do with that particular database, first thing being that particular conversion. Truth is that I don't know a first thing about db's, let alone using mysql... I downloaded mysql form www.mysql.com and...
63
5905
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 in Visual Studio to create reports and labels as it's in Access?` The advantage of VS.net is that not every user needs Access, right? And that would eliminate the Access version problem as well I guess.
25
4374
by: cory | last post by:
Hi, I have an Access database and am having an ASP.NEt application written for it. It is almost complete. I have a hosting company that I signed up with a month ago but before I did anything I asked them if Access and ASP.NET would work on their servers, they said yes so I bought in. Now they are saying my application wont work on their servers using MSaccess and I can only use SQL or asp 3.0. They are saying Microsoft is trying to...
49
14340
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The application is relatively big: around 200 tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data (SQL Server 2000), 40 users. I'm wondering what are the disadvantages of using Access as front-end? Other that it's not...
14
2439
by: D | last post by:
Hey guys- not sure where this post fits in, so I cc'd a few other groups as well- hope you dont mind... I have someone creating a database for me in Access 2000 (or is it called XP?). When it's all done, I'd like it to be online via the web. Ultimately I'd like just an online database accessed via ASP, PHP, CGI, etc- something (doesn't matter) but where various employees can access the thing from anywhere and do their work. It's been...
0
3728
by: TheCoder | last post by:
I am making a D-base with web conectivity for my class project. I have everything working but the subit button sends the data to the correct fields but afterwards it wants to reproduce new blank text boxes how do I stop this and how would I code it to redirect to a thank you page. All with out the help of a web server this has to br ran from the desktop and with in IE with a local directory. Pleas help I am stuck. here is the code! ...
15
2431
by: sparks | last post by:
We get more and more data done in excel and then they want it imported into access. The data is just stupid....values of 1 to 5 we get a lot of 0's ok that alright but 1-jan ? we get colums that are formatted for number and then half way down they are changed to text. OR the famous ok now everything in red is ---- and everything in blue is---------. WTF are these people thinking?
17
4408
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server database, just native jet database mdb created on Access 2003 (default 2000)...
16
6523
by: JoeW | last post by:
I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report, that I've also created within MS Access. I've attempted using the Access.Application instance, but I get errors when it tries to load the database. Just wondering if anyone has any experience with this, and what I should do. Thanks for any...
9
4757
by: Paul H | last post by:
As I understand it, to distribute a runtime version of Access 2003 with my app I need to spend £600 on "Visual Studio Tools for Office System package" which contains the RT plus a load of stuff I do not want. Or.... I can supply the client with a copy of "AccessRT.msi" which is on my Office 2003 pro CD and not tell anyone! Who is being more unscrupulous, me or Microsoft? Surely Microsoft forcing me
0
8674
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8603
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9157
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8895
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8861
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7725
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5860
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4369
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
2001
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.