943,793 Members | Top Members by Rank

Ad:
Oct 8th, 2008
0

HTML interface to an Access database

Expand Post »
I have an MS Access databse which supports a machine health monitoring application. I have the database schema but very little other documentation on how it has been constructed, very little support resource inside our own company to do any new development.
An important client has requested we provide a browsable HTML interface over a corporate intranet. We are considering using PC Anywhere, GOTOMY PC or a similar remote desktop but I am anticipating that this will not sit comfortably with the IT police on this site.
Is there anyone in the Daniweb community who can suggest an alternative solution and help me meet the requirement?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
LaurieArtesis is offline Offline
2 posts
since Oct 2008
Oct 10th, 2008
0

Re: HTML interface to an Access database

I may very well be just missing the bigger picture here but what is a remote desktop type interface going to help with in this case?

You could create some Web content to interact with the Access file but it would require the use of a language such as ASP, rather than just HTML.

Bill
Reputation Points: 10
Solved Threads: 2
Junior Poster in Training
BillBrown is offline Offline
60 posts
since Dec 2006
Oct 11th, 2008
0

Re: HTML interface to an Access database

Bill
Thanks for response, I am no expert in this field hence reason for looking for help.
I was thinking that remote desktop from one PC would access the screen displays of the Access application as if I was sitting at the Access terminal?
problem with this is only single user.
I had further feedback and the line we are going down is an Apache server and Jave code., but Im way out of my depth now.

Laurie
Reputation Points: 10
Solved Threads: 0
Newbie Poster
LaurieArtesis is offline Offline
2 posts
since Oct 2008
Oct 16th, 2008
0

Re: HTML interface to an Access database

Go to PHP gys in PHP forum. There are google video on issue just find them!
BTW good place to get answers is PHP forum!

Steve
Reputation Points: 462
Solved Threads: 392
Senior Poster
evstevemd is offline Offline
3,681 posts
since Jun 2007
Oct 17th, 2008
0

Re: HTML interface to an Access database

Hi Laurie,

No matter, really, which language your developer uses to interact with the Access file as long as it work properly to meet your needs. If your developer knows enough to want to use Java within an Apache environment, it sounds like you'll end up being in good shape when it's finished. :-)

Bill
Reputation Points: 10
Solved Threads: 2
Junior Poster in Training
BillBrown is offline Offline
60 posts
since Dec 2006
Oct 22nd, 2008
0

Re: HTML interface to an Access database

You used to be able to make such pages using wizards in Access but it was removed in Access 2007.
Moderator
Featured Poster
Reputation Points: 1764
Solved Threads: 574
Moderator
jbennet is offline Offline
16,505 posts
since Apr 2005
Oct 25th, 2008
0

Re: HTML interface to an Access database

so how do you do it in Access 2003, which wizard does it ?
Last edited by cjmike; Oct 25th, 2008 at 10:54 am.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
cjmike is offline Offline
6 posts
since Aug 2008
Oct 25th, 2008
0

Re: HTML interface to an Access database

on the left where there is tables, forms, queries etc... choose pages
Moderator
Featured Poster
Reputation Points: 1764
Solved Threads: 574
Moderator
jbennet is offline Offline
16,505 posts
since Apr 2005
Aug 5th, 2010
0
Re: HTML interface to an Access database
i just accept by the Twintech college as a labrian, they ask me to create a database for the labrary, i already finish the database (using Access 2003), now i want to create the interface using HTML but i dont know how to connect the HTML to the database.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
ashiro is offline Offline
1 posts
since Aug 2010
Aug 11th, 2010
0
Re: HTML interface to an Access database
Click to Expand / Collapse  Quote originally posted by ashiro ...
i just accept by the Twintech college as a labrian, they ask me to create a database for the labrary, i already finish the database (using Access 2003), now i want to create the interface using HTML but i dont know how to connect the HTML to the database.
Firts you have to know that HTML is *NOT* a language so you cannot definitely connect to database via HTML. It is a markup language with which you can only make UI (Tables, forms et al) No More. You need full fledged language like PHP, ASP,JSP etc.

I advice you go for PHP, learn it and do your job. I suggest PHP with SQLite or MySQL depending on whether you need server/embeded DB app.

http://www.w3schools.com/html/
http://www.w3schools.com/php/default.asp

EDIT: and start new threads instead of posting on eons old threads
Last edited by evstevemd; Aug 11th, 2010 at 9:52 am.
Reputation Points: 462
Solved Threads: 392
Senior Poster
evstevemd is offline Offline
3,681 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in IT Professionals' Lounge Forum Timeline: Want to know about framework.
Next Thread in IT Professionals' Lounge Forum Timeline: I need help. Can someone help me??





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC