Access97 database performance deteriorates when many concurrent connections are made to the database. So, if you are planning a very high traffic web site, Access may be suitable only for your initial efforts or it may not be suitable at all. Fortunately, there is a nice migration path available to move from Access97 to SQL6.5. This is the Microsoft technology which allows a programmer to connect to a database on the Internet. Then, we'll format and output the results of our work to an HTML page for a viewing browser.
Description is a text field.
I now proceed to create an ASP file which I will post on my Windows 95 Personal Web Server and which will read and list the table in the database. The first line simply declares that I am using VbScript for my scripting programming language. Microsoft was thoughtful enough to provide this file, but I will not cover what it does at this point in the interest of time. Finally, I type in my HTML header information followed by a Header statement and a horizontal line. Open cmdTemp, ,adOpenKeyset,adLockReadOnly RSlist.