Creating an access webpage

[Guest]

Hello,
I have a database set up for entering membership information for my
local church. I would like to create a website where people could come to to
view the church's information, and also if they wish to join the church. I
tried creating a webpage that links to the table that holds the membership
information, but when I vew the page, I can't add new date, I can only
display the existing data. Can anyone give me some suggestions.

Thanks,
Rev. Michael Waters

 

[Paxton]

How are you currently connecting to the database from the web page to
view the data? Are you using ASP or some other server-side technology?
Or have you created a data access page from within Access itself?

 

[Guest]

I used the option in access to create the page. I already had the database
with the form I'm using to enter the data. So from there, I went to the the
pages option, and used the wizzard to create a webpage. When I viewed it,
It lets me look through all the data, but not add new data. How I think I
would want it is so people can't change anyone else's info, but they can add
thier own. After thinking about it, I'm not even sure if I want them to be
able to view other people's info from website's form. I am going to generate
a membership list to place on the web, but it won't include all the data I
have in the database for each member.

 

[Paxton]

For doing what you want, your best option is to use ASP (Active Server
Pages). You would need a web hosting company that can host these (there
are thousands out there), and you would need to set up Internet
Information Services (IIS) on your computer to be able to test your
pages. You should have no trouble doing this if you have XP Pro, or
Windows 2000 Professional. Just go to Control Panel > Add/Remove
Programmes > Add/Remove Windows Components and then tick the box next
to Internet Information Services (IIS).

You would need to develop 2 pages - one would contain a form to accept
new members information and insert that into the database, and the
other would show whatever membership information you choose to display.

A good starting point for learning this type of stuff can be found
here:
http://www.w3schools.com/asp/asp_inputforms.asp

 

[Guest]

Thanks for the info, and the website. I'll look into it, and see what I can
do. If I have any other questions, I'll post them.