If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CREATE TEMPORARY TABLE
The help as well as the Microsoft website for MS ACCESS lists the syntax:
CREATE [TEMPORARY] TABLE... Yet, any attempt to use the "TEMPORARY" keyword leads to a syntax error. Is this a documentation error that Microsoft has acknowledged - or is this a software error? Which is wrong? Best Regards, Andy |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Hi,
Are you using DAO or ADO? I've not come across this usage, but I don't do a lot with ADO so I'm guessing it's Jet 4 or more. I tried ADO and I even submitted the SQL statement directly from within Access (using RUNSQL). In either case, the keyword "TEMPORARY" is recject - even though it IS document (and elaborated on) in the JET 4.0 SQL help file "JETSQL40.CHM" that comes with Access, and the appropriate document on the Microsoft website. I understand that I can manually create and drop tables within on session. I'm just trying to find out whether this SHOULd work, e.g., if this is a documentation bug - or if this is a "software problem". I didn't find any knowledgebase article that states that this is a documentation error - or otherwise. Best Regards, Andy |
#4
|
|||
|
|||
Hi Chris:
Thanks for the reply. Access does not support true Temporary Tables like other DBMS products. That's what I'm suspecting as well - I've been given the task to get the "official" word. Do you have any reference - I couldn't find any KB article that "withdraws" the how-to information they published in their help file and on their support web site. When doing .adp, I would imagine SQL Server's "CREATE TABEL #tablename" syntax would follow Good thinking - I quickly tried the "#" syntax against JET and that is not valid either (I know you were talking about .ADP projects and SQL server, but I couldn't lose trying...). Andy |
#5
|
|||
|
|||
I tried all the things I could think of that it seemed to me might make a
difference. I used ADO. I turned on the SQL Server compatible (ANSI 92) option. I converted to Access 2002/2003 format. Nothing worked. I tested the query by taking out the TEMPORARY keyword, to eliminate the possibility of some other syntax error in the query. Worked fine without it, just wouldn't work with it. Unless someone else knows different, it looks like a documentation error to me. -- Brendan Reynolds (MVP) "Andy Schmidt" Andy wrote in message ... The help as well as the Microsoft website for MS ACCESS lists the syntax: CREATE [TEMPORARY] TABLE... Yet, any attempt to use the "TEMPORARY" keyword leads to a syntax error. Is this a documentation error that Microsoft has acknowledged - or is this a software error? Which is wrong? Best Regards, Andy |
#6
|
|||
|
|||
|
#7
|
|||
|
|||
"Brendan Reynolds" brenreyn at indigo dot ie wrote in
: I tried all the things I could think of that it seemed to me might make a difference. I used ADO. I turned on the SQL Server compatible (ANSI 92) option. I converted to Access 2002/2003 format. Me too: even going up straight against SQL Server with OSQL, I get this - 1 create temporary table Tim1 ( 2 TimNum integer constraint pk primary key, 3 AnotherField varchar(32) null 4 ) 5 go Msg 156, Level 15, State 1, Server ALESI, Procedure , Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'temporary'. 1 I think the Books Online give an alternative version for creating temp tables in SQL Server. In Jet, it's easiest just to create a new database, make the tables in it, and erase the mdb afterwards. All the best Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update Tables using forms | achett | Using Forms | 5 | January 28th, 2005 01:25 AM |
Get data from combo box to popluate the next box | Lin Light | Using Forms | 4 | December 30th, 2004 06:01 PM |
Q1: How to create a boolean table field in code? | Jeff Conrad | General Discussion | 5 | August 11th, 2004 08:22 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
What I would like to do is create a report from data stored with in a table (tbl_consultations) with the following criteria:- | Barry McConomy | General Discussion | 1 | June 7th, 2004 11:55 PM |