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

 

Thanks for your response, much appreciated

 

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

 

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