Wrox Programmer Forums
ASP.NET 1.x and 2.0 Application Design Application design with ASP.NET 1.0, 1.1, and 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.x and 2.0 Application Design section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 18th, 2007, 11:31 AM
Authorized User
Join Date: Feb 2007
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem with creating table

im trying to create a table with the code below. However it says the table already exists. I've tried to create a bnew database and delete all the table but it still says the table already exists. on checking the db the table does exist but how do i stop the code going back andtrying to create another table thanks

  Dim conADO As ADODB.ConnectionClass = New ADODB.ConnectionClass
        Dim strSQL As String
        Dim tableN As String
        tableN = Surname & Name.Substring(0, 1)

        conADO.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source='Y:\Copy of eplanet\dbUsers.mdb'", Nothing, Nothing, 0)

        strSQL = "CREATE TABLE " & tableN & " (UserN string, QuesNo Integer1, " & _
                                       "QuesCat string,userAns string,correctAns string,Result string,Score Integer1,DateOfTest string);"

        conADO.Execute(strSQL, 0, 0)

Similar Threads
Thread Thread Starter Forum Replies Last Post
creating table ph0neman Classic ASP Basics 3 January 22nd, 2008 05:06 PM
Creating table with existing table without value kumar_kumar Oracle 1 January 4th, 2005 07:12 AM
Creating a table programmatically Bob Burns ASP.NET 1.0 and 1.1 Basics 2 July 15th, 2004 11:44 AM
Creating an Image in a table nvillare VBScript 1 May 26th, 2004 12:26 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.