Not Enough Space On Temporary Disk When Open/run Ms Access Append Query

S

SMAZ

Joined
Jul 20, 2005
Messages
2
Reaction score
0
Hi,

I am new to this forum.
@ I have a mdb and i linked many sql server tables in it. (TABLE_SQL). The number of recrods in this table are in 9 figures
@ I have a table in MS access (same in which i linked MS SQL Tables) (TABLE_MDB). The number of recrods in this table are in 3 figures
@ I create a Append Query (Make table) (QUERY_APPEND)
In this query is I join the (TABLE_SQL) with (TABLE_MDB) and Insert all records in a new MS Access
Table (NEWTABLE_MDB)
@ Whenever i ran this query it will shows an error message (Not enough space on temporary disk)
@ I serached on net a found article on microsoft site and impletnt its method(1) & (3) but issue is still there.

I'll appreciate if anyone help me in this regard.

THANK
SMAZ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append query in Access to SQL Server 2
Access 2010 append query to SQL is very slow 0
Error 3183 Not Enough Space on Temporary Disk 3
Not enough space on temporary disk 5
access 2003 table not visible in append query 4
not enough space on temporary disk 1
Not enough space on temporary disk. 1
Linked Tables Append Query(ies) 4

Top