Export Data to fit into HTML and JavaScript Files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are creating an application that has two parts - a front-end with HTML and
JavaScript, and a back end created with Access. When the Access materials
are updated, we need to be able to export those files and convert to HTML and
Javascript so the front end will be automatically updated. Would anyone have
any sugesstions on what strategy might work best? Thanks so much!
 
Roger:

I agree but we're limited to delivering the product on a CD Rom... we did
consider ASP or ASP.NET. So we have to do it this way. I'm thinking we have
to add VBA code in for when the database is compiled. Does that sound close?
 
Sorry about that, here's what we have:

1) A web-based front end in HTML and JavaScrpt. The HTML holds all the
data, while the JavaScript has some smaller pieces of data... The user
selects and item via a pulldown menu, and it returns results through a
seperate frame (iframe js command).

The back end has an application in MS Access written with VBA and a GUI.
The user can update data.

What we need to do is have a way for the additional/edited data to be sent
to us and an .mdb file (similar to what's built into Access now where you can
save something as HTML) to enter in the proper HTML and JavaScript files;
that way the front end files are automatically updated.

The people wanting the project want a CD-ROM delivery, so we can't do any
ASP or .NET... just acts as a stand alone piece.

Hope that makes sense. Let me know if you need any further clarification.

KGD
 
Is this something that needs to be dynamic? That is does the customer
expect to make changes to the database and have the data automatically
updated? Or is it just a matter of them sending you the data, you update
the web pages and send it to them on CD?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Well, whatever does the job... we just need Access to specifically fill the
various HTML tables and JavaScript code that validates old and new addresses.
 
Roger,

I think the process would be very similar to ACess 2000; so if you have that
installed, a solution should be identical.
 
As a few others mentioned, both queries, and reports built in ms-access can
be sent out as html.

So, just build your report layouts, and import the new data...and gen the
reports.....

I suppose you could hand write the code in java to attached to a particular
table in the mdb file, and loop for each record
(in fact, if you did this, you would not need to install, or use ms-access
on the machine). But, this
sounds like a lot of work when you can save repots, and even queries in
ms-access as html.

By the way, you can also export the data as xml also.

It is not 100% clear if you have input forms in html...and how you drive the
data for these. However, for just data reports, the report writer will
export to html......

Remember, if you are just using the mdb file, then you don't need ms-access
installed to read, or extract data. You can even write a windows script.
(each copy of windows ships with the JET engine, and thus you can open/read
a mdb file without needing ms-access installed -- any software environment
that can consume a ADO, or DAO data object can open a mdb file.

Heck, you can even write a windows batch file to open a mdb file when you
don't have ms-access installed.....

However, in your case...I think the html reports is the least effort way....

It is also not clear if the end users will have a copy of ms-access here or
not....
 
PMFJI. I get the impression that you want to distribute an update to your
application in the form of an MDB that contains code that can create new
HTML and JavaScript files on a web server.

If that's right, is it a matter of storing the HTML and JavaScript files in
the MDB and simply putting them in the correct places in the web server's
file system? If so, how about creating a table with two fields:
tblExternalFiles
FileSpec* (text, contains the path and name of the file)
Contents (memo field containing the HTML or JavaScript code for the
file)

It's then simple to write code that will create the files.

Or do you want to generate *custom* HTML and JavaScript files that use
information that is not available to you when you create the CD on which you
need to distribute the application? If so, it's unlikely that the standard
"export to html" facility will be any use. You'll probably need to write VBA
code to generate the files (probably with the aid of "boilerplate" material
stored in a table as above).

Or have I got totally the wrong end of the stick?
 
Back
Top