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

[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

[Tom van Stiphout]

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

[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

[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