Board index Office Access

Make Table with SQL Pass Through

Make Table with SQL Pass Through

Post by SumAp » Wed, 24 Dec 2003 02:17:07


I have SQL Pass through Query. I want to create a Table
with that Query in Access. I used SQL pass through query
in Access Make Table query to create the Table, but it
takes forever to create the Table. Is there a a way that
i can create Table in Access using a SQL Pass Through
Query but NOT using Access Make Table Query ?

I hope i did not confuse ppl with my posting ?

Thanks,

SumApr
 
 
 
Top

Make Table with SQL Pass Through

Post by Duane Hook » Wed, 24 Dec 2003 10:07:51

Is your make table query based on only the Pass-Through? Does the P-T run
quick? This shouldn't take much time to run.

--
Duane Hookom
MS Access MVP

 
 
 
Top

1. Sybase temporary tables with SQL pass-thru

2. Pass-thru vs non-pass thru query in DAO

3. Appending Table name into another table table thru SQL query

4. writing a Sql table data to a text file thru T-SQL

5. SQL pass thru query from code always prompting for DSN

6. Pass thru Query problem - converting from a case /replace in SQL

7. sql pass thru to oracle error

8. Pass thru - Select from two tables joined on three fields

9. Make Table Query based on Pass-Thru Query

10. SQL pass thru query from code always propting for DSN

11. Pass-thru SQL performance vs Stored Proc

12. SQL Pass Thru

13. Why SAS SQL pass-thru to Oracle so slow?

14. Oracle pass-thru query gives "ORA-00933: SQL command not

15. Using a local table to create a Pass-Thru Query

All times are UTC
Board index