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

Web based Access DB. What technologies to learn?

P: n/a
Hi

I would appreciate advice concerning what I need to learn to develop a
web based database which I need to create as part of my computer
course.
The database will be fully web based, it should allow members of a
club
to subscribe to various groups and will enable group leaders to send
email to the group.

I have reasonable experience with Access, little or none of: HTML, VB,
VB Script, ASP. I realise I have a lot to learn, but am a quick and
dedicated learner.

How much of the following is correct with regard to the software I
need to use?
???
-Access (2002)
-VB Script
-ASP.net
-something to generate HTML - possibly notepad or a simple HTML editor
-IIS or PWS for development - XP Pro
-A web server capable of hosting ASP.net pages
???

Is there a VB Script.net?

Assuming the database will by only usable from the web, what else will
be required in the access database apart from tables, relationships
and
queries?
Should macro's or events be included in the database or in the VB
Script. eg to trigger the procedure which will send email?
What technology will I need to send email to each group?

Can anyone recommend any good tutorials (online or book) for vb Script
and asp.net?

Could anyone point me to a very simple, complete solution (which I can
download and play with) based on a few web pages connected to a simple
Access DB with perhaps a couple of tables and queries.

Is VB.net an alternative solution?

http://www.awprofessional.com/title/0201734400

suggests some of the things that VB.net will do, including Web Forms
(which I believe is another name for an ASP.NET page).
How different would this solution be to the Access / VB Script /
ASP.net
solution above? Would / could it include Access as the database, or
would a complete VB database need to be created?

Thanks Colin
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Colin Kingston wrote:
Hi

I would appreciate advice concerning what I need to learn to develop a
web based database which I need to create as part of my computer
course.
The database will be fully web based, it should allow members of a
club
to subscribe to various groups and will enable group leaders to send
email to the group.

I have reasonable experience with Access, little or none of: HTML, VB,
VB Script, ASP. I realise I have a lot to learn, but am a quick and
dedicated learner.


Not exactly what you're asking for, but another possible
alternative:

http://in.geocities.com/samdarshipal...-php-mysql.htm

I had an Access-based VB app that ported over to using
MySQL with surprisingly few changes. I recommend it.

*And* they're all free! ;)
Nov 13 '05 #2

P: n/a
Colin Kingston wrote:
Hi

I would appreciate advice concerning what I need to learn to develop a
web based database which I need to create as part of my computer
course.
The database will be fully web based, it should allow members of a
club
to subscribe to various groups and will enable group leaders to send
email to the group.

I have reasonable experience with Access, little or none of: HTML, VB,
VB Script, ASP. I realise I have a lot to learn, but am a quick and
dedicated learner.

How much of the following is correct with regard to the software I
need to use?
???
-Access (2002)
-VB Script
-ASP.net
-something to generate HTML - possibly notepad or a simple HTML editor
-IIS or PWS for development - XP Pro
-A web server capable of hosting ASP.net pages
???

Is there a VB Script.net?
This list is suitable if you are stuck in an MS world. Get a machine with
Win2k/2003, add Access and .Net. Go to the .Net walkthroughs in MSDN and
you will soon have some web pages working. These will get your hands dirty
fast, but you will have to do some real studying to get them useful.

For what you are suggesting, you can probably ditch the whole .net stuff
altogether as unnecessary and just use plain old ASP. If the purpose is to
learn methods, this simpler approach will let you learn about the basics of
dividing up the project into browser, web server, and db server. Then when
you have learned more about it you can form your own judgements about more
complicated stuff.


Can anyone recommend any good tutorials (online or book) for vb Script
and asp.net?

Could anyone point me to a very simple, complete solution (which I can
download and play with) based on a few web pages connected to a simple
Access DB with perhaps a couple of tables and queries.


Google or sourceforge.net. All of the good examples I can give you are on
PHP, such as phpGrouWare.
--
Kenneth Downs
Use first initial plus last name at last name plus literal "fam.net" to
email me
Nov 13 '05 #3

P: n/a
Xitami works ok on xp
Patrick

On Sun, 31 Oct 2004 19:20:45 GMT, Dennis Lee Bieber
<wl*****@ix.netcom.com> wrote:
On 31 Oct 2004 04:44:43 -0800, ck****@yahoo.co.uk (Colin Kingston)
declaimed the following in comp.databases:
Hi

I would appreciate advice concerning what I need to learn to develop a
web based database which I need to create as part of my computer
course.
The database will be fully web based, it should allow members of a
club
to subscribe to various groups and will enable group leaders to send
email to the group.

Install Plone, and be done with the entire effort <G> {Python,
Zope, CMF, and a pre-built CMF application design all-in-one}
How much of the following is correct with regard to the software I
need to use?
???
-Access (2002)
-VB Script
-ASP.net


Do you /have/ to use Access? Same for the other items you
mention. Lots of sites run MySQL for the database, using various
languages -- depending on the server, PHP, PERL, Python, others... If
using CGI (slower and clumsier than things like Zope that are built for
the purpose) then there is practically no client-side work to be done,
and anything that can be started by the CGI handler in the server can be
used on the back-end.
-something to generate HTML - possibly notepad or a simple HTML editor


For hand-written HTML... I doubt you want to pay the cost of
HomeSite... The full Mozilla package has an editor.
-IIS or PWS for development - XP Pro


PWS doesn't run on XP -- I believe XP Pro comes with IIS (pity
my laptop came with XP Home; no server available on it).


Nov 13 '05 #4

P: n/a
Have you tried web matrix??

http://www.asp.net/webmatrix/default...dex=4&tabId=46
I am using web matrix for my asp.net project because visual studio is
too expensive for me. It is only 1.3 Mb size but can do all sort of
thing that
Visual studio.net can do. They have good tutorial on their site ...
http://www.asp.net/webmatrix/tour/ge...ted/intro.aspx
I think it will help you a lot.
Suvra B
http://www.M6.net
Always On :: Always Performing :: Always Hosting
Nov 13 '05 #5

P: n/a
Have you tried web matrix??

http://www.asp.net/webmatrix/default...dex=4&tabId=46
I am using web matrix for my asp.net project because visual studio is
too expensive for me. It is only 1.3 Mb size but can do all sort of
thing that
Visual studio.net can do. They have good tutorial on their site ...
http://www.asp.net/webmatrix/tour/ge...ted/intro.aspx
I think it will help you a lot.
Suvra B
http://www.M6.net
Always On :: Always Performing :: Always Hosting
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.