Go Back   Computer Forums > Web Design | Website Development > Web Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 06-06-2010, 09:35 PM   #1
Beta Member
 
Join Date: Jun 2010
Posts: 4
Default Microsoft Access --> HTML --> Microsoft Access

Hi everyone. This is my first post (probably of many, I'm a forum junkie...)

I'm working on a three part project and I want some advice.
I want to know how I can take information from a microsoft access database and send it/convert it/whatever to a website.
Eg. Someone updates news in a database macro and the information is updated on the website.

Second question. How could we then send information from said website to another access database.
Eg. Someone types in a complaint in a text field on the website and it is sent to database.

Any advice would be helpful. I have a broad range of skills, but I'm new to Microsoft Access.
__________________

tvellalott is offline   Reply With Quote
Old 06-07-2010, 05:07 PM   #2
Site Team
 
berry120's Avatar
 
Join Date: Jul 2009
Location: England, UK
Posts: 3,425
Default Re: Microsoft Access --> HTML --> Microsoft Access

How much do you know about PHP / SQL databases? If you know how to do it with SQL then it's just a case of using a different database drive for Access:

http://www.w3schools.com/PHP/php_db_odbc.asp

The above URL gives examples.

Quote:
Someone types in a complaint in a text field on the website and it is sent to database.
You'd typically have a server side application running that'd receive the results of the form via a GET / POST request - the server side application can then choose to do what it likes with the data, including adding it into another database.

Usually these are done in PHP, though Java servlets are another option. Have a Google around for PHP / Servlets and databases and you should find some pretty good articles about how to go about things (there's lots around.)

That said, I'd typically advise against using access wherever possible - it's a terrible database system! Oracle is of course the big, paid for corporate giant but I'd honestly recommend MySQL or PostgreSQL (both free) - the former is more popular but the latter is more fully featured (allows you to do OO for example.) If I had to pick I'd use MySQL any day over Access!
__________________

__________________
Save the whales, feed the hungry, free the mallocs.
berry120 is offline   Reply With Quote
Old 06-07-2010, 08:07 PM   #3
Beta Member
 
Join Date: Jun 2010
Posts: 4
Default Re: Microsoft Access --> HTML --> Microsoft Access

I know access is horrible, but client has specifically requested it. When they realise how slow it down the track we will probably have to convert the system to a better database, so more work I suppose.

Thanks for the feedback anyway.
tvellalott is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 10:15 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0