Web enabling of access database

[Nandini]

I have created a bibiliographic database using Access 2003. I have designed
necessary forms for user interface to retrieve data. Tables, parameter
queries and forms including necessary visual basic codes are designed for
proper functioning of the database. I want to make this database web-enabled.
So that data can be retreived from this database through internet maintainig
necessary security. But I dont want to create any data access pages, as this
object has some limitations. For doing so what should I design -- ASP or
install ASP.Net. Again where will I get necessary guidence? Anyone can help
me anyway?
With best regards,

 

[Daniel Pineault]

First and foremost, it must be understood that Ms Access is not meant to be a
web based database. Don't get me wrong, I love Ms Access, but one does need
to know the limitation of a tool. Depending on the number of users, and many
other criteria, you might want to truly rethink this one before you proceed.

That said, it is true that you can create webpages that use an Ms Access
database as it's source. If you google the term "Ms Access asp.net" you will
find lots of related information to get you going. All that is really
required is a server side language such as asp, php... so you can work with
whichever language you are more confortable and your website hosting provider
supports.

As usual the W3Schools.com had a tutorial on the subject. This would be a
good starting point to learn the basics. You can access it at:

http://www.w3schools.com/aspnet/aspnet_dbconnection.asp
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.