Need Help! [Microsoft Access]

Please Help ! [Microsoft Access]

[shanky]

hi there the webmasters i need your help people. i am woking in a medical billing firm as a trainee medical biller my boss wants me to develop a little website which he wants to use for some information i mean which contain not more than one table and some data like date and account number, name, and some notes in it he wants to do it on a web site which i think do need a database on the backend i have made a form in microsoft access but i don;t know how to connect it with a webpage can any one help me please send me some little project like that so i can edit it and use it as per my requirements this will be a great help to me.

thanking you in advance i am eagerly waiting for a reply.

[edited by: Woz at 1:01 pm (utc) on Sep. 21, 2005]
[edit reason] Let's keep the discussion on the board please. [/edit]

[tantalus]

Hi shanky welcome to WW.

I am not too sure whether this the best forum for your question.

Its more of a qustion of which scripting language you should use to access your database, transform the data and render it to the user as html

As you're using an access database I'd suggest researching "asp" or "asp.net". w3schools have some great tutorials and theres also the "Microsoft Related - .NET and ASP" forum here on webmasterworld.

Anyway you have some studying to do. I don't think anyones going to hold your hand on this one, unless you have some specic problems and examples that you can actually post for people to view.

[ergophobe]

What I would do in your case (in fact, what I have done to get an Access DB online) is

1. Take your form from Access and just mimic it on a web page. If you don't know HTML, you can use something like Dreamweaver or Nvu (converting static sites that were built using FrontPage into dynamic sites has caused me nothing but irritation, but I know others will beg to differ). Easiest thing is to make sure that all form fields have the same name as the data field will have in the database.

2. Convert your DB to MySQL. It will be just so much easier to find web hosting. There are other, and for many purposes, better database systems, but MySQL has become almost ubiquitous, so it's a good place to start for what sounds like a trial project.

[webmasterworld.com...]
[webmasterworld.com...]

3. Build the script that will get the data from one to the other. That can range from simple to very difficult depending on needs.
[webmasterworld.com...]