Convert HTML to a Access database

I am trying to create a simple tech support ticketing system for the department I work for.  What is the best way to take information off of an HTML form and have it uploaded to a MS Access database?  
MarkRJacksonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

b0lsc0ttIT ManagerCommented:
You need to use a server language to get the information from the form and put it in the database.  Some common languages are ASP/vbscript, PHP, and Perl.  What does your web server support?

Let us know the language and I can provide some information on how to get the form info, connect to the database and add the info to the database.  When you find out what type of server language you can use you may also want to find out the options you have to connect to an Access database file.  The best way to do this is without a DSN and using the Access driver.  You could confirm with your web host that this is an option you can use on your web server.

Let me know what additional information you need or questions you have.

bol
0
MarkRJacksonAuthor Commented:
I should have explained it more in detail but here is my problem.  It is a web page that is on a local intranet and the HTML files are put on to a file server and not a web server.  I am trying to create just a simple ticketing form so I can keep track of the jobs that are open or complete.  
0
b0lsc0ttIT ManagerCommented:
If you aren't using a web server then this is a little out of my expertise.  I believe a "data access page" will help you.  You can search for info on those in Access' Help file.  If I recall it can produce "pages" or applications that can run on their own and be used to access the database.  If you need more help on that then a pointer question in the Access database topic area would be helpful.  This isn't the best area for that type of question.

Let me know how this helps or what addtional information I can provide.  I will be happy to do what I can but I have very limited experience in this area. :)

bol
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
b0lsc0ttIT ManagerCommented:
I'm glad I could help.  Thank you for the grade, the points and the fun question.

bol
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
HTML

From novice to tech pro — start learning today.