Pulling values from a Table onto the web? 3

[drewpgc]

Hello all,

I would consider myself a novice to almost intermediate with access.

Anyways what I need to do seems pretty simple. I just need to make a web page that pulls values from a table we have stored on our server. The users WILL NOT need to modify the info, they simple need to view it.

I want it set up so that when users modify the table locally here at our company, people from another site can view the changes on the internet...

Thanks for your time!

 

[Remou]

How do you see this happening? Would the people viewing on the internet be viewing one of your servers? Would the people updating be updating on the same server? Do the changes need to be viewed real time or would an upload at various times be suitable?

 

[drewpgc]

Well the database file is physically ON our server, there are two ladies who update the tables maybe 3-4 times daily with invoice/customer information.

So essentially yes, users here at the company will be updating the SAME database table that I want people offsite to be able to view...

But yea basically I was just going to make a webpage off of our mainpage, that shows realtime what the data in this table is. If it is not realtime, I am willing to just have it updated once at the end of the day if theres a way i can create an html file.

 

[Remou]

Your options include:

* Saving forms and reports as static web pages.
This is the easiest to do and the most tedious to keep up to date.

* Using Data Access Pages (DAPs).
This is also quite easy to do and will show data real-time, but it can be difficult to get information, as DAPs are not generally used.

* Creating ASP or ASP.Net pages.
This is more difficult, but not too difficult, I think, when all you wish to do is show data, rather than update it. This, too, will give you real-time data.

Don't forget to use a split database.

 

[drewpgc]

Thanks again for your reply...

Are there any tutorials out there on how to do this with ASP pages? I am assuming I will not need to purchase any additional software for this will I?

Also, what do you mean split databases?

 

[Remou]

You can start here:

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

A split database is one that has the data in one database and the forms etc in another. You will find a Database Splitter under Tools in Access, but read up a little first.

 

[dhookom]

Try type "asp tutorials" into Google. You need to run IIS on a PC/Server in order to run ASP pages.

"Split" databases suggests placing all of your tables in one MDB (the back-end) and all the queries, code, reports, macros, ... in another MDB (front-end).

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[drewpgc]

ok thanks again guys, unfortunately we do not run IIS, I just started working for this company and put it this way, the server has 512k of ram lol.

We are getting a new server at the start of 08, maybe until we get it, i can just do the publishing of html pages for now.

Thanks again for all the info everyone!

 

[fneily]

If you search this forum on "data access page" or DAP, you'll find lively discussions on which to use DAP's or ASP.
With DAP's, you'd be finished by now.
As Remou said, DAP's are not used that much. I've found that people who program in ASP or SQL and/or are Database network support just didn't know you can create DAP's so they don't use it.
I've created an online system using just DAP's for my state transportation department. So you can use them for a large project.
However, and this is where Mr. Remou has my goat, Microsoft stopped any further development on DAP's with Access 2007.