By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,081 Members | 2,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,081 IT Pros & Developers. It's quick & easy.

"Not enough space on temporary disk" (Access 2003 mde)

P: n/a
PW
Hi,

One of our clients is getting that error when they are trying to save
a record but I can not duplicate it here. The data is on another PC
and is linked to two workstations.

The code (listed below) is just saving interests selected from a
multi-list list box.

I've never seen that error message before. Any ideas? What does it
mean by "temporary disk"?

-paulw

*----

Set db = CurrentDb
Set rs = db.OpenRecordset("tblClientInterests")
Set ctl = Me.[lstSelected]

' First delete any records that might exist for the client:

db.Execute "DELETE * FROM " _
& "[tblClientInterests] WHERE ClientID = " &
Forms![frmClientEntry]![ClientID] & ";"

' Write the selections to the table:

For i = 0 To ctl.ListCount - 1
varItem = ctl.ItemData(i)
rs.addnew
rs![interest] = varItem
rs![ClientID] = Forms![frmClientEntry]![ClientID]
rs.Update
Next

rs.Close
Set rs = Nothing
Set db = Nothing
Set ctl = Nothing
Aug 9 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Thu, 09 Aug 2007 16:33:47 -0600, PW
<pa**********************@removehotmail.comwrote :

The disk that the "TEMP" environment variable points to.
Start Run cmd.exe SET
or Control Panel System Advanced Environment Variables.

-Tom.

>Hi,

One of our clients is getting that error when they are trying to save
a record but I can not duplicate it here. The data is on another PC
and is linked to two workstations.

The code (listed below) is just saving interests selected from a
multi-list list box.

I've never seen that error message before. Any ideas? What does it
mean by "temporary disk"?

-paulw

*----

Set db = CurrentDb
Set rs = db.OpenRecordset("tblClientInterests")
Set ctl = Me.[lstSelected]

' First delete any records that might exist for the client:

db.Execute "DELETE * FROM " _
& "[tblClientInterests] WHERE ClientID = " &
Forms![frmClientEntry]![ClientID] & ";"

' Write the selections to the table:

For i = 0 To ctl.ListCount - 1
varItem = ctl.ItemData(i)
rs.addnew
rs![interest] = varItem
rs![ClientID] = Forms![frmClientEntry]![ClientID]
rs.Update
Next

rs.Close
Set rs = Nothing
Set db = Nothing
Set ctl = Nothing
Aug 10 '07 #2

P: n/a
PW
On Thu, 09 Aug 2007 19:56:16 -0700, Tom van Stiphout
<no*************@cox.netwrote:
>On Thu, 09 Aug 2007 16:33:47 -0600, PW
<pa**********************@removehotmail.comwrot e:

The disk that the "TEMP" environment variable points to.
Start Run cmd.exe SET
or Control Panel System Advanced Environment Variables.

-Tom.
Thanks Tom for the heads up! I am not sure if they have Access on
their system though.

-paulw
>
>>Hi,

One of our clients is getting that error when they are trying to save
a record but I can not duplicate it here. The data is on another PC
and is linked to two workstations.

The code (listed below) is just saving interests selected from a
multi-list list box.

I've never seen that error message before. Any ideas? What does it
mean by "temporary disk"?

-paulw

*----

Set db = CurrentDb
Set rs = db.OpenRecordset("tblClientInterests")
Set ctl = Me.[lstSelected]

' First delete any records that might exist for the client:

db.Execute "DELETE * FROM " _
& "[tblClientInterests] WHERE ClientID = " &
Forms![frmClientEntry]![ClientID] & ";"

' Write the selections to the table:

For i = 0 To ctl.ListCount - 1
varItem = ctl.ItemData(i)
rs.addnew
rs![interest] = varItem
rs![ClientID] = Forms![frmClientEntry]![ClientID]
rs.Update
Next

rs.Close
Set rs = Nothing
Set db = Nothing
Set ctl = Nothing
Aug 11 '07 #3

P: n/a
PW
On Thu, 09 Aug 2007 19:56:16 -0700, Tom van Stiphout
<no*************@cox.netwrote:
>On Thu, 09 Aug 2007 16:33:47 -0600, PW
<pa**********************@removehotmail.comwrot e:

The disk that the "TEMP" environment variable points to.
Start Run cmd.exe SET
or Control Panel System Advanced Environment Variables.

-Tom.

LOL! Nevermind! It's not an Access thing. A wee bit tired tonight
<BG>. Do you know what Access uses that folder for?

-paulw
>>Hi,

One of our clients is getting that error when they are trying to save
a record but I can not duplicate it here. The data is on another PC
and is linked to two workstations.

The code (listed below) is just saving interests selected from a
multi-list list box.

I've never seen that error message before. Any ideas? What does it
mean by "temporary disk"?

-paulw

*----

Set db = CurrentDb
Set rs = db.OpenRecordset("tblClientInterests")
Set ctl = Me.[lstSelected]

' First delete any records that might exist for the client:

db.Execute "DELETE * FROM " _
& "[tblClientInterests] WHERE ClientID = " &
Forms![frmClientEntry]![ClientID] & ";"

' Write the selections to the table:

For i = 0 To ctl.ListCount - 1
varItem = ctl.ItemData(i)
rs.addnew
rs![interest] = varItem
rs![ClientID] = Forms![frmClientEntry]![ClientID]
rs.Update
Next

rs.Close
Set rs = Nothing
Set db = Nothing
Set ctl = Nothing
Aug 11 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.