Thread: SQL and ASP
View Single Post
Old Jul 7th, 2006, 10:24 AM   #2
java_roshan
Professional Programmer
 
Join Date: Mar 2005
Location: Student of University of Mumbai, Maharashtra State, India
Posts: 344
Rep Power: 4 java_roshan is on a distinguished road
If you create a blank database, in MS-access, you can issue SQL commands to create tables. i.e.
1. Create a blank database with no tables

2. Create an ASP file, including the connection code, and write create table statements. Include a subroutine to check for errors, that might creep up, if any. (make use of err.Number, err.Description, to simplify your work)

3. Use Response.Write statements, if there are no errors, to display, "Successfully created a table"

and yes, use Mozilla Firefox
__________________
Visit: http://www.somaiya.edu
java_roshan is offline   Reply With Quote