Database onto the Internet for public viewing

[bloody_football]

Hi all,
I have done a multi user database for a private company (and thanks to all those that helped me out) but now I need to do another database to put onto the Internet so the general public can view it and order the products. Obviously some of the database needs to be private (so I can update records) but some needs to be viewed over the Internet. I would like the general public to be able to view the products over a web page, not download a program to view the database.

I have made the database already so I can pull up a web page (from within access) and order the products - all I need to know is how to do this over the Internet?

I don't expect anyone to hold my hand through this, I just ask if anyone has a link to a walkthrough so I can do this?

Regards, James

PS Have another question -
I have 17, 500 records and I wish to add a new Field, how can I change the values of the Field without going thorugh them one by one? e.g If the Record has 'Rarity = U' then I want the 'price' (which is the new field) to equal 1.

 

[Meltdown]

If you want to use your database on the internet, then you need to learn ASP/ASP.net. DAP's can not be used as they require the end-user to have MS Office XP installed.

In regard to your second question, add the new field to your table, then make a new Update Query using the required Table, drag the Rarity field and your new field to the query grid, set the Criteria of the Rarity field to 'U' and the Update To: field (of the new field) to 1. Run the query and you're done.

 

[bloody_football]

Thanks Meltdown

Know of any good sites to learn ASP?

 

[krberube]

I have been wanting to fool around with MS access over web pages ( more powerful than DAP) but haven't had the time. I believe (don't take my word for it) something like Macromedia's ColdFusion MX7 would be a good tool to start with. their dreamweaver MX2004 product is awesome for doing websites ( buy a book though).
I believe they have a trial download you could fool around with.

 

[jeremie_ingram]

Just a suggestion, but I would much rather build the HTML interface in either Front Page or (better yet) Dream Weaver, and then use it to link/display the data from your access database. Both integrate very well with access, and also allow you the restrictive/selective control you are looking for.

 

[atisz]

Something new

Just a suggestion, but I would much rather build the HTML interface in either Front Page or (better yet) Dream Weaver, and then use it to link/display the data from your access database. Both integrate very well with access, and also allow you the restrictive/selective control you are looking for.

I use Dreamweaver from quite a long time, but i didn't knew it can be used with Access. Can you be more specific, about how to display/link data from an access database?
Thanks in advance.
Attila

 

[jeremie_ingram]

Straightfrom the help files of DW.

To create a database connection in Dreamweaver:
-Open any ASP page in Dreamweaver and then open the Databases panel (Window > Databases).
-Click the Plus (+) button on the panel and select Data Source Name (DSN) from the pop-up menu.
-The Data Source Name (DSN) dialog box appears.

--Enter connTrio as the connection name.
-(Windows only) Do one of the following:
-If your server is on your local computer, select the Using Local DSN option.
-If your server is on a remote system, select the Using DSN On Testing Server option.
-Macintosh users can ignore this step because all database connections use DSNs on the testing server.

--Click the DSN button and select TrioMotors from the list of DSNs.
If you’re using Dreamweaver on a Windows computer, then during installation, Dreamweaver created a DSN called TrioMotors pointing to the Microsoft Access database in the Samples\Database folder in the Dreamweaver MX 2004 application folder.

--Click Test.
Dreamweaver attempts to connect to the database. If the connection fails, do the following:

--Double-check the DSN.
Check the settings for the folder Dreamweaver uses to process dynamic pages (see Specifying where dynamic pages can be processed).
Consult "Troubleshooting Database Connections" in Using Dreamweaver Help.
Click OK.
-The new connection appears in the Databases panel.

The sample ASP application is now set up for the Getting Started with Dreamweaver tutorials. For more information, see Tutorial: Developing a Web Application.

 

[jeremie_ingram]

There are too many varibles in such a setup, and they all depend on what you have and where it works from. Here is a quick snippet straight from the help files of DW. I suggest you brose the F1 repository to see what it has in lines to match your needs.

To create a database connection in Dreamweaver:
-Open any ASP page in Dreamweaver and then open the Databases panel (Window > Databases).
-Click the Plus (+) button on the panel and select Data Source Name (DSN) from the pop-up menu.
-The Data Source Name (DSN) dialog box appears.

--Enter connTrio as the connection name.
-(Windows only) Do one of the following:
-If your server is on your local computer, select the Using Local DSN option.
-If your server is on a remote system, select the Using DSN On Testing Server option.
-Macintosh users can ignore this step because all database connections use DSNs on the testing server.

--Click the DSN button and select TrioMotors from the list of DSNs.
If you’re using Dreamweaver on a Windows computer, then during installation, Dreamweaver created a DSN called TrioMotors pointing to the Microsoft Access database in the Samples\Database folder in the Dreamweaver MX 2004 application folder.

--Click Test.
Dreamweaver attempts to connect to the database. If the connection fails, do the following:

--Double-check the DSN.
Check the settings for the folder Dreamweaver uses to process dynamic pages (see Specifying where dynamic pages can be processed).
Consult "Troubleshooting Database Connections" in Using Dreamweaver Help.
Click OK.
-The new connection appears in the Databases panel.

The sample ASP application is now set up for the Getting Started with Dreamweaver tutorials. For more information, see Tutorial: Developing a Web Application.

 

[jeremie_ingram]

There are too many varibles in such a setup, and they all depend on what you have and where it works from. Here is a quick snippet straight from the help files of DW. I suggest you brose the F1 repository to see what it has in lines to match your needs.

To create a database connection in Dreamweaver:
-Open any ASP page in Dreamweaver and then open the Databases panel (Window > Databases).
-Click the Plus (+) button on the panel and select Data Source Name (DSN) from the pop-up menu.
-The Data Source Name (DSN) dialog box appears.

--Enter connTrio as the connection name.
-(Windows only) Do one of the following:
-If your server is on your local computer, select the Using Local DSN option.
-If your server is on a remote system, select the Using DSN On Testing Server option.
-Macintosh users can ignore this step because all database connections use DSNs on the testing server.

--Click the DSN button and select TrioMotors from the list of DSNs.
If you’re using Dreamweaver on a Windows computer, then during installation, Dreamweaver created a DSN called TrioMotors pointing to the Microsoft Access database in the Samples\Database folder in the Dreamweaver MX 2004 application folder.

--Click Test.
Dreamweaver attempts to connect to the database. If the connection fails, do the following:

--Double-check the DSN.
Check the settings for the folder Dreamweaver uses to process dynamic pages (see Specifying where dynamic pages can be processed).
Consult "Troubleshooting Database Connections" in Using Dreamweaver Help.
Click OK.
-The new connection appears in the Databases panel.

The sample ASP application is now set up for the Getting Started with Dreamweaver tutorials. For more information, see Tutorial: Developing a Web Application.