There is a database in Access 2007 that contains a table with two fields. Let's call it field_1 and field_2.

And there is a [ file A ] and a [ file B ]

I want a script that do this: I write in A -> The thing i wrote is being writen in the database -> B shows automatically the text i wrote.

Would you like to try and explain that again?? only be a little less vague.

English is not my first language but i will try.

For example, in an asp file i will text "hello world" and then save. Save to the database. The textbox and save button will be conected to the [field_1] or [field_2]. Then there is another asp file used by a diferent user that will show what the other user wrote.

English is not my first language

Sure, if your English vocabulary is limited then an example of what you are trying to do can be much simpler.

So is it that you you want to know how forums, blogs, CMS's, or any other page that takes user input and then displays it to another viewer make it actually happen?

Originally Posted by chrishirst

Sure, if your English vocabulary is limited then an example of what you are trying to do can be much simpler.

So is it that you you want to know how forums, blogs, CMS's, or any other page that takes user input and then displays it to another viewer make it actually happen?

Yes, something like that.

A question I should have asked is,

are you learning vBscript or JScript?

Yes, but by myself (through tutorials, e-books, samples)

Which one?

ASP has two languages VbScript (Visual Basic Script) and JScript (server side javascript).

VbScript is the default language and as such the most common one for ASP developers to use.

vbscript

ok

Just to demonstrate that it is not a "black art" www.modtalk.co.uk is coded entirely in vBScript by myself, well there are a few lines of jScript which handle the "elapsed time" functions for the page generation timing

There is a misconception in web development languages that seems to consider that you need one page to collect data and one to display this is not so, a single page can do both just as easily, if not moreso.

There are hundreds of tutorials around on what you are trying to do and rather than me re-inventing it's probably worth pointing you to them then you can ask specific question based on what you don't quite grasp.
So first of all:

What do you know about database schema design, db concepts and Structured Query Language (SQL)?

Originally Posted by chrishirst

ok

Just to demonstrate that it is not a "black art" www.modtalk.co.uk is coded entirely in vBScript by myself, well there are a few lines of jScript which handle the "elapsed time" functions for the page generation timing

I would never say it was built in vbscript.

Originally Posted by chrishirst

ok

What do you know about database schema design, db concepts and Structured Query Language (SQL)?

I don't understood your question. I worked with access 97 2003 and 2007 / Apache server / my sql, more i guess but i can't remember. In this project, just access 2007.

Originally Posted by chrishirst

What do you know about database schema design, db concepts and Structured Query Language (SQL)?

Originally Posted by madseason

I don't understood your question. I worked with access 97 2003 and 2007 / Apache server / my sql, more i guess but i can't remember. In this project, just access 2007.

So not much then

Access files when used as a website database server are quite slow, especially on insert queries and they are limited for running concurrent processes.
Very useful during the learning process but far from ideal on production websites that have more than a moderate load.
So you have to learn how to build efficient data structures, table schemas and write efficient queries, such as avoiding the use of "SELECT * FROM" especially in a JOIN query.
Unfortunately writing dB structures within the single session access "desktop database" environment of Access or using the "wizards" to build the schema is relatively poor preparation for the multiple access website website where a quick response is paramount.

So you need to be learning several disciplines at once, not least of which is DBA (database administration).