A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

CREATE TEMPORARY TABLE



 
 
Thread Tools Display Modes
  #1  
Old January 26th, 2005, 10:25 PM
Andy Schmidt
external usenet poster
 
Posts: n/a
Default 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




  #3  
Old January 27th, 2005, 08:56 PM
Andy Schmidt
external usenet poster
 
Posts: n/a
Default

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  
Old January 27th, 2005, 09:04 PM
Andy Schmidt
external usenet poster
 
Posts: n/a
Default

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  
Old January 27th, 2005, 09:17 PM
Brendan Reynolds
external usenet poster
 
Posts: n/a
Default

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






  #7  
Old January 28th, 2005, 06:06 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default

"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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.