Access Database Online? (basic)

[simon.robin.jackson@gmail.com]

Ok, please bare with me, im not a web developer. I am an intermediate
Access database user.

We collect data for a company that has 20 monitoring stations. Once a
month they collate all the data together and send it to us. We have
an access database that (via macros) we merge the data into. This has
been going on for a few years now.

If they want to know something about their data, they ring up, we look
at the database and send out a report that relates to their request.

I would like to suggest something which would allow the client better
accessibility to the data. i.e. Put it on their intranet, and they
could search
for records based on key words, or drop-downs showing months or
something.

Something else (that doesnt need discussing here) is that Id also like
to have a google map
hack, showing the station locations, and via clicking a marker, will
then load the
relevant data from the database (linked via an ID)

This may give a slightly better idea of what im after:

http://i7.photobucket.com/albums/y254/jak-c/Ideas.jpg

(apologies, the image got stretched at some point, still readable)

Id like to upload the Access database every time it gets updated.
Then have a online web
query system to allow users to view data, perhaps choose a drop down
to select between two different dates (which as a result changes a
graph), search by keyword, station name, etc. I know little about
this but very keen to learn - am i right in thinking I should be
taking a javascript approach to this???

Any hints, tips, pointers, similar project experience would be really
appreciated. I dont want to jump in and say I can do something thats
not feasibily possible.

Thanks in advance.

[simon.robin.jackson@gmail.com]

Re: Access Database Online? (basic)

With some research with Google, it appears perhaps Data Access Pages
are where I should be concentrating?

However, id still prefer to upload the database directly to the server
as opposed to have the data stored in HTML.

Also heard Front Page is a solution, but dont think client will have
license to use front page on their intranet.

Id really appreciate if someone could set me straight on what options
I have with Access database, hosting it on a intranet and having some
basic queries to look at the data.

[Bob Alston]

Re: Access Database Online? (basic)

simon.robin.jac kson@gmail.com wrote:

With some research with Google, it appears perhaps Data Access Pages
are where I should be concentrating?
>
However, id still prefer to upload the database directly to the server
as opposed to have the data stored in HTML.
>
Also heard Front Page is a solution, but dont think client will have
license to use front page on their intranet.
>
Id really appreciate if someone could set me straight on what options
I have with Access database, hosting it on a intranet and having some
basic queries to look at the data.

An intranet is generally an internal internet, where all users are on a
LAN. In that situation, Data Access pages would seem to work.

Data Access pages don't seem to work well in a true internet
environment, due to security issues with the method Microsoft uses with
data access pages.

Options that I see

1)I suggest you consider whether you could periodically send the users
refreshed/updated copies of the database that they would use on a
read-only basis.

2) Use some software that would allow you to make Microsoft Access
reports available via the web, but still have the database only on one
server. See

http://webpages.charter.net/bobalston/AccessDB.htm#Run%20Access%20Reports%20from%20Web

3) Develop a web application to display the data from your Access database.

Bob

[graformix.com - professional design studio]

Re: Access Database Online? (basic)

Hello,

You can try dbforms apps from dbconvert.com

Regards,
Dmitry

On Feb 11, 8:23 pm, "simon.robin.ja ck...@gmail.com "
<simon.robin.ja ck...@gmail.com wrote:

Ok, please bare with me, im not a web developer. I am an intermediate
Access database user.
>
We collect data for a company that has 20 monitoring stations.  Once a
month they collate all the data together and send it to us.  We have
an access database that (via macros) we merge the data into.  This has
been going on for a few years now.
>
If they want to know something about their data, they ring up, we look
at the database and send out a report that relates to their request.
>
I would like to suggest something which would allow the client better
accessibility to the data.  i.e. Put it on their intranet, and they
could search
for records based on key words, or drop-downs showing months or
something.
>
Something else (that doesnt need discussing here) is that Id also like
to have a google map
hack, showing the station locations, and via clicking a marker, will
then load the
relevant data from the database (linked via an ID)
>
This may give a slightly better idea of what im after:http://i7.photobucket.com/albums/y254/jak-c/Ideas.jpg
(apologies, the image got stretched at some point, still readable)
>
Id like to upload the Access database every time it gets updated.
Then have a online web
query system to allow users to view data, perhaps choose a drop down
to select between two different dates (which as a result changes a
graph), search by keyword, station name, etc.  I know little about
this but very keen to learn - am i right in thinking I should be
taking a javascript approach to this???
>
Any hints, tips, pointers, similar project experience would be really
appreciated.  I dont want to jump in and say I can do something thats
not feasibily possible.
>
Thanks in advance.