Error 3183

[Guest]

Not enough space on temporary disk. (Error 3183)
You tried to perform an operation that requires more space than is available
on the temporary disk. Your temporary disk location is based on the TEMP DOS
environment variable, which was set when your system started.
For example, you may be trying to create a query that creates temporary
files larger than the temporary disk. Reduce the size of the temporary files
by accessing smaller amounts of data at one time or increase the size of the
temporary disk.
You can increase the amount of available temporary disk space in several
ways:
• Select fewer records. Dynaset-type, forward-only – type, and snapshot-type
Recordset objects record keys and data to the temporary disk.
• Select a different drive for your temporary disk.
• If the temporary disk is a RAM disk, increase the amount of available RAM
and the space allocated to the RAM disk, or move it to a fixed disk.
• Free some space by deleting data or by removing unneeded tables, queries,
forms, macros, and modules from your database.
• Free some space by compressing deleted records out of your database.
• If you still need additional space, consider removing other unused files
from your disk.
*******
Does Access have its own configuration for assigning temporary files. We
cannot understand where the files are and why they are inadequate.

Running an append query from AS400 to MDB.

HELP...

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Have you tried the suggestions to free up disk space?

Access uses the Windows O/S virtual disk/file allocation functions.

Is the query an SQL Pass-thru query? That means all the
sorting/grouping is done on the AS400 and returns only the records you
requested. If not try making it one. AS400 uses IBM DB2 SQL syntax.

Access temp. tables are usually stored in the \temp folder of the
current Windows user, or the C:\temp folder. Is there a size limit on
that folder?

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQgK5eIechKqOuFEgEQKM9gCgpDqd+lNcpgV/F0PhIcMPmi4LQ+YAoKKn
SLTxKFytAgv6G05BcQesZSxc
=zOE3
-----END PGP SIGNATURE-----

 

[Chris2]

Not enough space on temporary disk. (Error 3183)
You tried to perform an operation that requires more space than is available
on the temporary disk. Your temporary disk location is based on the TEMP DOS
environment variable, which was set when your system started.
For example, you may be trying to create a query that creates temporary
files larger than the temporary disk. Reduce the size of the temporary files
by accessing smaller amounts of data at one time or increase the size of the
temporary disk.
You can increase the amount of available temporary disk space in several
ways:
• Select fewer records. Dynaset-type, forward-only – type, and snapshot-type
Recordset objects record keys and data to the temporary disk.
• Select a different drive for your temporary disk.
• If the temporary disk is a RAM disk, increase the amount of available RAM
and the space allocated to the RAM disk, or move it to a fixed disk.
• Free some space by deleting data or by removing unneeded tables, queries,
forms, macros, and modules from your database.
• Free some space by compressing deleted records out of your database.
• If you still need additional space, consider removing other unused files
from your disk.
*******
Does Access have its own configuration for assigning temporary files. We
cannot understand where the files are and why they are inadequate.

Running an append query from AS400 to MDB.

HELP...

Bev,

I believe it's talking about the Windows Swap File. Make it bigger
(rebooting the PC will be necessary).


Sincerely,

Chris O.

 

[Guest]

Is there a tool available for easily converting the MS Access SQL to the IBM
DB2 SQL syntax? I am not experienced in this syntax.

 

[MGFoster]

Is there a tool available for easily converting the MS Access SQL to the IBM
DB2 SQL syntax? I am not experienced in this syntax.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you don't use any Access functions or VBA functions in the query you
can pretty much use JET (Access) SQL syntax, which is ANSI-89 SQL (ANSI
92 in Access 2002/3).

You probably can find some references to DB2 on the Web. Try Googling
for "DB2 SQL." Perhaps this site for starters:

http://www-306.ibm.com/software/data/db2/udb/support/

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQgQMaoechKqOuFEgEQJgKQCgrsBBjhTYYaysgSsDTeTAvFkTE1YAoLq6
J70YLOQO3vnf5TuZPjtWbqG0
=Qt7T
-----END PGP SIGNATURE-----