access database / forms on website

  • Thread starter Thread starter Wayne-I-M
  • Start date Start date
W

Wayne-I-M

Hi

I am just starting to make the on-line application form for our 2010 trips
(I know, long time to go but bookings coming in already).

Simple questions maybe not too simple answer.

I understand that many peole (not me) can create websites that have complex
forms but it's just beyond my skill level - but I can create Access databases
that do everything needed.


Can I put an Access form on a website.
How can I have all the functionality of an access database on-line ?

Are there any website that give details

Many thanks
 
No - Access won't run as an application on a website.

With asp or asp.NET programming you can emulate most of the features of
an access database, including the forms and sub forms.

Start at http://www.w3schools.com.

The Database Results Wizard and Database Interface Wizard in FrontPage
will take you some of the way, but you really need to get to grips with
asp or asp.net.

In my opinion, once you have learnt how to put a page together in
asp.NET (and that's not hard with Expression Web), asp.NET is easier
than "classic" asp, especially if you use Access to write most of the
SQL queries for you.
 
No you can't use Access Forms on a web site
(the web does not support VBA)
- but you can use an access DB if your host supports Access (on a Windows server)

As a start you can try using a form sending to database
- and get the results using the database results wizard
See http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp and http://spiderwebwoman.com/resources/diwtipsandtricks.asp
Or use classic ASP (easiest to learn if you know VBA) and ADO code to customize your form/results
See http://www.w3schools.com/asp/default.asp
and http://www.w3schools.com/ado/default.asp
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi
|
| I am just starting to make the on-line application form for our 2010 trips
| (I know, long time to go but bookings coming in already).
|
| Simple questions maybe not too simple answer.
|
| I understand that many peole (not me) can create websites that have complex
| forms but it's just beyond my skill level - but I can create Access databases
| that do everything needed.
|
|
| Can I put an Access form on a website.
| How can I have all the functionality of an access database on-line ?
|
| Are there any website that give details
|
| Many thanks
|
|
| --
| Wayne
| Manchester, England.
|
 
Hi

Thank you both for the answers, I am learning this "web stuff" - very slowly
:-)

Think I will go for mysql as it's on the host's server and I not too bad at
this.

Thanks again
 
If you need a form to database & email feature try www.appnitro.com

It offers a form designer and backend processing/administration function
(PHP/MySQL) - it can post to a database and email to your webmaster (or
whoever you wish) and also an auto reply the the person posting the message
through the form (I see questions about that all the time on this group).

The good thing about this is that you can then put the created forms on any
site. The application itself can be hosted on one domain, and stores all
the records and data in its database. At this time, it's only a single
user - for the Admin person, and doesn't allow any type of user management
for individuals to edit their own records etc.

If you want just a form designer (no back-end code) then try
www.phpform.org - this is the "lite" version of the above -

I'm sure Veign mentioned the above some months ago, which prompted me to
purchase the product, because I think it's the best I've seen around.
 
Thanks for that Andrew,

I’ll have a look at in next week. I suppose I’m like a lot of people in
that I prefer to stick with what I know. I have been designing quite complex
databases for large scale multiple users for quite a while and to create the
front end data input (the form) would be so simple in access, but of course
the big drawback is that the process I use simply won’t work on this medium
(the web), oh well I’ll just have to bite the bullet and have a go at
something new :-)

Thanks again
 
Back
Top