Temporary Tables in ASP / Jet 4

Results 1 to 2 of 2

Thread: Temporary Tables in ASP / Jet 4

  1. #1
    Rob Guest

    Default Temporary Tables in ASP / Jet 4

    Can you use temporary tables with a Jet 4 database? i have code that is similar to: (the hash makes it a temporary table) <BR><BR>&#060;% <BR> strSQL = "CREATE TABLE #UniqueWords (Words);" <BR> Set oConn=Server.CreateObject("ADODB.Connection") <BR> oConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="d:/data/mydb.mdb;" <BR> oConn.Execute strSQL, ,adCmdtext <BR><BR> oConn.Execute "DROP TABLE #UniqueWords;", ,adCmdText <BR>%&#062; <BR><BR>in my asp page but the page returns: <BR><BR>Error Type: <BR>Microsoft JET Database Engine (0x80040E14) <BR>Syntax error in CREATE TABLE statement. <BR>/zzz.asp, line 27 <BR><BR>i have searched MSDN, technet etc but have for no reference to this. <BR><BR>if you know, you&#039re a star!!! <BR><BR>rob

  2. #2
    Forum Police Guest

    Default CROSS POST


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts