Make Table Query Hangs

[Guest]

Hi,

I have a make table query, which results in approximately 600 rows being
created into a table. It runs fine on my machine. When my colleague tries
to run the same query, it stalls about halfway through, at which point Access
ceases to respond. A select query with essentially the same SQL runs fine on
his machine, as does a make table query resulting in 30 records. Does anyone
have any ideas what the problem could be? We've got macro security set to
low (not that that should make a difference).

Thanks,
Harry

 

[Guest]

Hi Harry,

My only guess is a lack of available space in the Temporary files folder on
your friend's PC and/or environment variables that do not point to the
correct location.

The Local Settings Temp folder is usually defined as:
C:\Documents and Settings\UserName\Local Settings\Temp

On your colleague's computer, click on Start > Run. Enter the command: SET
Look for two lines that define the TEMP and TMP folders. Verify that these
paths are valid on this PC. Use Windows Explorer to navigate to these
folders. Delete built-up temporary files that may be present.

Click on Start > Run and enter: %windir%\temp
Clean out temporary files and folders from this location as well.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Oops. This sentence:

On your colleague's computer, click on Start > Run. Enter the command: SET

should have read:

On your colleague's computer, click on Start > Run. Enter the command: CMD
Then enter the command SET at the DOS prompt.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________