Website - MS-Access - JavaScript
lazarus / 8-Other

----------------------------------------------------------------------
LazaruX · 2009-02-17 12:55

Hi,
I have got an IT question and most probably you will help me in having
the answer.
I am making a website. I want to have it as simple as possible.
I have read it is possible trough JavaScript to read from an MDB (ms
access) file.
My question is, is this save enough?
I just need to do SELECT * FROM somewhere

I want avoid to use PHP (i cannot program it) or ASP.NET (don't like
.NET), and I want to keep it simple.

----------------------------------------------------------------------
Loesje · 2009-02-17 13:15

It's impossible for a java-script running on the client to read from
an access-database on the server, without using any other technology.


You could use an fpc-application, though. You need the fpweb-package.
Then just create a new cgi-application. Add one action and make it the
default. Add an html-db grid component from the fpweb-tab to your
form. Add the necessary db-components and configure the executable as
bein a cgi-script on your server.

In short.

----------------------------------------------------------------------
faulkj · 2009-04-22 18:59

You are able to connect to Microsoft Access using JavaScript when the
HTML file is run locally and the Access .mdb file is accessible to the
file system - it does not work remotely due to the obvious security
issues.

I had a situation where this functionality was actually useful, so I
wrote a JavaScript library to simplify the process.  This library
allows you to execute SQL queries in a single command with the option
of selecting the output format of the result-set from choices
including JSON, XML, and HTML.

I had a great deal of difficulty finding information or examples of
how to connect to Access, so I decided to share my code with the
world...

The library is called ACCESSdb and you can get it here!