By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,636 Members | 1,915 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,636 IT Pros & Developers. It's quick & easy.

Using Access in web app?

P: n/a
JED
I have an opportunity to work on a web based project using Access. However,
there has been a suggestion that MySQL might be a better alternative. The
project is actually a small project (less than 4000 table rows) and I feel
Access would work well. I lean toward using Access since there is a current
offline Access application related to this project. I feel that keeping the
underlying software similar makes for easier interaction between the two.
Dream Weaver will probably be used to generate ASP web pages. I have found an
ISP who can host an Access database. How practical is it to use Access as a
back-end database in a web app? Does Microsoft approve of using Access in a
web app? Can Access hold its own in this situation? What problems can I
expect? Can Access be made secure?

Jul 22 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
It'll do fine for a small web system. But, remember no system stays small, they all keep growing!

'dlbjr
'Pleading sagacious indoctrination!
Jul 22 '05 #2

P: n/a
I love Access for non-high traffic sites. And yes the database could be
the same as the desktop database but the Web pages would of course just
be using the tables. For example if the Web pages read data from the
database then one could FTP the latest database up anytime one wanted.

And if the site writes data then it is easy to back up the Web site data
just by FTP downloading the one Access .mdb file.

If the site gets very slow or the DB gets corrupted then consider
upgrading the database to something more industrial-strength like MySQL.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Jul 22 '05 #3

P: n/a
"repeated answer"

It is correct that you should "go further, bigger and more robust" data save
solution when building web apps. But at the same time i have built web apps
with access db for more 50 users and there hasn't even go or slow down at
all after 6 months. Remeber these 50+ users are not "really accessing the
db at the same time. The recordsets are disconnected.. They're accessed
and the db is released. Of course on these cases, the applications are not
critical neither 24/7 and it won't cause any big damage if it goes down for
a while. Some of these access db are holding 80000+ rows and works fine for
the processes designed for. Be careful what you need out of it. Some
processes could significantly slow down your web app performance. And as a
suggestion do not relay on it, and backup that mdb everyday.

It all depends on your needs or company needs and the growth of the
application. In my case this was used to save costs by the company and it
is known that the growth of these activities are not closer than 10 years.
So, my customers are happy with the solution. for some others and
differents cases I have had to go with oracle or SQL Server.

--
________________
German Saer
gs***@hotmail.com
Orlando, FL

"Bullschmidt" <pa**@bullschmidt.com-nospam> wrote in message
news:ub**************@TK2MSFTNGP12.phx.gbl...
I love Access for non-high traffic sites. And yes the database could be
the same as the desktop database but the Web pages would of course just
be using the tables. For example if the Web pages read data from the
database then one could FTP the latest database up anytime one wanted.

And if the site writes data then it is easy to back up the Web site data
just by FTP downloading the one Access .mdb file.

If the site gets very slow or the DB gets corrupted then consider
upgrading the database to something more industrial-strength like MySQL.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***

Jul 22 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.