Display Access data records on a webpage

blothrop

New member
Local time
Today, 18:34
Joined
Jan 12, 2011
Messages
2
I’m creating a website that will handle tons of data, using MS SQL Server for the active content, basically dropping records into a variety of webpage templates for the end-user. But, my back-office first has to sort through tons of raw data and whip it into shape, drafting and editing text, cropping/resizing photos, assigning links, etc. I’m using Access 2003 for that process, to handle everything that is not yet ready to be imported into the SQL Server for publication to the live website.

I understand that I can display data from an Access db on a webpage, somehow (just a facsimile of the real webpages in which it will be displayed, later, one record at a time). It would be very helpful for the back-office staff to have an in-house, interactive way to see how the data they’re editing will eventually appear on the website, giving them insights into how they need to adjust it further.

My head is reeling from all of the different stuff I’ve read about how I might do this. Can you all give some general advice on how I should get started, which direction I should take?

[FONT=&quot]Thank you.[/FONT]
 
Last edited:
This is a very simplified explanation but for starters:

1) You need to create a local intranet available to the backoffice if you want them to see the impact on the web site. A pre-production environment seems to be used.

2) All images should be in a web format and resolution which can be reused for Access, assuming referemtial linking to the images.

3) I don't know what you mean by assigning links?

4) Using Paging use can see more than one record and progress through a recrodset start to finish.

5) Request.QueryString("Variable") allows you to qualify the data to a single or grouping of records.

Simon
 
Last edited:

Users who are viewing this thread

Back
Top Bottom