Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Newbie question (http://www.go4expert.com/forums/newbie-question-t1665/)

jazzlall 18Oct2006 18:16

Newbie question
 
Quite new the world of access - I know the basics pretty much. What I wanted to know, and I am sorry if this sounds like a really stupid question, but hoping someone will be able to give me some advice.

I am looking to design a database in access which is fully accessible on the internet also on a webpage. What would need to be done to achieve, a few people I have spoken to have mentioned ASP.net & ADO.net.

Is it just a matter of creating the entire database locally and then using some code to upload it on the internet, making sure my host supports asp etc?

Thanks in advance

shabbir 19Oct2006 09:59

Re: Newbie question
 
Quote:

Originally Posted by jazzlall
I am looking to design a database in access which is fully accessible on the internet also on a webpage. What would need to be done to achieve, a few people I have spoken to have mentioned ASP.net & ADO.net.

The persons whom you have asked have told you the perfect solution and to have anything on web you need web languages and the best language is ASP / ASP.net

Quote:

Originally Posted by jazzlall
Is it just a matter of creating the entire database locally and then using some code to upload it on the internet, making sure my host supports asp etc?

Yes.

jazzlall 19Oct2006 19:50

Re: Newbie question
 
Thanks for your response, much appreciated :)

shabbir 21Oct2006 09:00

Re: Newbie question
 
My pleasure.

jazzlall 22Feb2007 17:29

Re: Newbie question
 
I have pretty much completed the access project, which includes tables, forms , reports, queries etc. It also have a front end on for easy navigation for my uncle (it's for him)

Just slightly confused about putting it on the internet now. What would you recommend would be the best way to do this, obviously using ASP is the solution, but what application shall I use. Could it be done in frontpage with aspx files which would trigger the .mdb to be opened through the webpage? Or isn't it as easy as that.

Thanks in advance

ever_thus 1Mar2007 05:27

Re: Newbie question
 
aspx pages allow you use code behind pages written in VB or C#. In the aspx page (which is mostly like a normal html page), you would lay out the controls that get things like the query fields and passwords from the user. Each control is associated with an event handler, which means that when you do something to the control, a method with says handles <event> is called. In that event handler you do what you want.

The event handlers are, as I said written in VB or C#. Both provide methods for opening databases (Access or otherwise), making queries, and suchlike. For instance to open a database you code Connection.open () (where Connection is a Connection object representing your database). Most of this is done with calling the appropriate methods on .NET database objects.

When you've got something to send back to the user, you give it a name that appears in your aspx page, and/or invoke an event that will display it. In the aspx you use names defined in the code behind in tha format <%name%>.

That's it in short. To get the details like sytax and supported objects look at W3C's ASP.NET tutorial, MSDN's ASP reference and MSDN's VB reference


All times are GMT +5.5. The time now is 10:59.