Solved

Automate webpage (table) to update from access db

Posted on 2008-10-28
13
176 Views
Last Modified: 2010-04-21
Afternoon Experts,

I am desparate to find a way of automating a process currently in place of update a table displayed in a webpage.  Currently im exporting table results from Access to excel where i use macros to format the table( remove duplicates, append last column with duplicates) using another macro i create a XML file from formated table.  I then use js code to format the table in a webpage.  This seems like a lengthy process i would love to pull the currents webpage table from the access leaving out a bulk of the steps while still using js code to take care of formatings.  Unfortuneatly i have no idea where to start.  Can anyone ofter any insight?
0
Comment
Question by:thirsty4knowledge
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
  • 2
13 Comments
 
LVL 11

Expert Comment

by:miqrogroove
ID: 22825047
Typically this would be done by hosting the database on a web server that is running a script processor (such as PHP or ASP) for dynamic output.

If you absolutely had to generate static HTML files, then I think your best bet would be to download the latest free version of Visual Basic and compile an executable program to handle the work.
0
 

Author Comment

by:thirsty4knowledge
ID: 22825104
Ok, it seems to me that i would be able to convert the database in access to the db server (not sure on difficulty).  Then hopefully use the js code as opposed to PHP or ASP to do the scripting of formatting??  I dont know that i need static HTML files?? Why would this be needed can i not refrence table stored on web server using the same html im currently using? Please let me know if im being unclear.  Thanks 4 quick response!
0
 
LVL 11

Expert Comment

by:miqrogroove
ID: 22825193
Perhaps we should be clear about what you mean by "automating".  Do you need the table to be updated in real time when someone makes any change in the database?  Or do you just want a click-once solution to manually regenerate your web page when you want to do that?
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 11

Expert Comment

by:SeanStrickland
ID: 22825219
You would need to do this in ASP or PHP as you need a server-side language to process/display your data.  Here is a link to a prior EE question that shows you how to do this via PHP.

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_21357675.html

PHP is a free, open-source processing language.  This allows web hosting companies to offer a web server with PHP installed very cheap.  ASP is usually a bit more expensive to host, but I can find a link for ASP for you as well if you need it.  I would recommend PHP.

To do this, you would load the access database file to your web host and use the PHP script in the above link to access the information that you need.
0
 

Author Comment

by:thirsty4knowledge
ID: 22825231
It seems either way would work so long as when the user opened the page data is shown with an option to update.  Ideally would love a real time reflection of data.  
0
 
LVL 11

Assisted Solution

by:miqrogroove
miqrogroove earned 250 total points
ID: 22825306
A PHP solution similar to SeanStrickland's ODBC example would give you real-time access to the data for HTTP output.  However, you're going to be coding in PHP not VBA, and if your desired result is an XML file instead of an HTML file then you would have to learn how to do it in the new language.

So we have some options for you here and I think you'll need to decide the exact result you'd like to get and how much time to invest into learning languages.
0
 

Author Comment

by:thirsty4knowledge
ID: 22825483
Ok, 2 points i think my clearify and lead to a god enough solution.  \

I was using the macro generated XML to display data via the js code but only using XML b/c the js code was designed to read from a XML file.  Thus offered downloading to user since i already was creating one; dosn't need to b the case.  The option for downloading a XML file is not important.

Website currently has pages/ tables utilizing ASP setup.. these page were put into place prior to my working on this project.  I have no experience in ASP but am thinking that tools are in place should convert using ASP since we are current housing ASP pages.  
0
 
LVL 11

Expert Comment

by:miqrogroove
ID: 22825560
ASP does have similar ODBC libraries, and I believe you can also make a direct ADO connection to the Jet engine, which is probably preferable for an Access database.  The database file would have to be accessible to your IIS server, and you would need to know some ASP, ADO, and Jet SQL to make it totally seamless.
0
 
LVL 11

Accepted Solution

by:
SeanStrickland earned 250 total points
ID: 22830559
Here's a good EE Solution that shows you how to connect to your MS Access Database via ASP.

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21006799.html?sfQueryTermInfo=1+access+adodb+asp+connect+ms
0
 

Author Comment

by:thirsty4knowledge
ID: 22832052
Ok, so it looks like I have all the resources i need to update html with ASP code to refrence MS Access DB; for which i thank all contributing parties.  At this point my question lies on the begining stages of getting this task started.  My db (access db) is house on one server  (server 10) and my IIS is house on another (websever 10) must the two be on the same sever or can i use a path for seamless interaction mentioned prior??  Also it looks like ill be using ASP to tackle this problem.  Does anyone know of some good resources on formatting tables via ASP???
0
 
LVL 11

Assisted Solution

by:miqrogroove
miqrogroove earned 250 total points
ID: 22833491
I would get the ASP script up and running with a local copy of the database before attempting to do this with two servers.
0
 

Author Comment

by:thirsty4knowledge
ID: 22833875
Ok, that makes sense.  

I will award both 'migrogroove' and 'seanstrickland' point since both suggestions will be used to solve my problem.  Thanks guys.. your lifesavers!!
0
 

Author Closing Comment

by:thirsty4knowledge
ID: 31510884
I now have background and information to get this complete.  Thanks!!
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question