I'm pretty new at access. I just started reading a book on it and plan to become at least somewhat proficient and knowledgeable after it. But i was just wondering if it is possible to put an access database online. For example, what I wanna do is this:
I'm in a house with about 60 other guys and I want to make a profile section on our webpage that will let visitors know who's in the house, what their major is, maybe a picture, hobbies etc. I was gonna store this information in an access database. I was wondering if there is anyway to transfer this database's content onto a webpage in a layout that I design. I heard asp was the way to go for this but do not know how to go about it. Any help would be good! Thanks!
I would definately suggest ASP using VBScript - simply because VBA and VBScript are not 100 miles a part.
Now I know I'll get htis next bit wrong and somoene will correct me - but an Access database to an ASP page will use an ADO connection : I suggesat you take a peek at these in your book.
Infact, take a look at ADO and DAO and ODBC connections (simply to cover my own answer )
I'm with GeorgeV all the way on NEVER even open frontpage! DreamWeaver is the software of choice. It will walk you through the connection to the database and write most of hte ASP for you, but it does not leave a 1000 extra, unnessary lines of code in your web page like FrontPage does.
And Paul was right about ASP, you will need a Windows server. Who ever you are look at to host your web page, they will need to support ASP.
I have a web site supporting over 12,000 images running on top of an Access 97 database. Yes it is possible and yes it works. You will need to find someway of defining the aspect of the images and these can be collected by your database and used thus:
I just tried the exporting a database to html feature and it just puts it exactly like it looks in access itself in a very simple table. What i need to do is make a layout for each database entry (like the name at the top, split the middle row into two columns, one with a picture, one with some more information etc. etc.) to make it look nice and professional and then have a space between each entry. Or maybe even a separate page for each entry. Can this be done?
I just read the chapter on reports and messing with the design of reports. I think I have my solution there. Just kinda make it the way I want it and export it to html. This is a very caveman strategy but for the knowledge that i got, i'm not doing too bad
Now the next question is,
I'm tryin to make a member profile section for my fraternity. There's about 60 guys in the house and I want the page to say their name, year in school, major, hobbies, a picture etc. Is there anyway I can make a form that they can fill out (without having to use access) that will populate a database automatically so I make a report with it. I could always just collect their information by hand and input it myself but I'd like to save the time. I'm thinking I need to do something online for this with a server, please offer some guidance!!