FIX: Run-time Error "This Array is Fixed or Temporarily Locked" (176049)

The information in this article applies to:

Microsoft Visual Basic Learning Edition for Windows 5.0
Microsoft Visual Basic Professional Edition for Windows 4.0
Microsoft Visual Basic Enterprise Edition for Windows 4.0

This article was previously published under Q176049

SYMPTOMS

With an .exe file made from a Visual Basic project, you receive the following error:

Run-time error 10:
"This Array is fixed or temporarily locked"

The error does not occur when the Visual Basic project is run in the design environment.

CAUSE

This error occurs when your project uses the Microsoft Data-bound Grid control and you pass an element of a variant array to a procedure in a class module. This problem only occurs in Visual Basic 5.0 if the Visual Basic 5.0 Service Pack 2 or Service Pack 3 is installed.

RESOLUTION

There are several possible workarounds for this problem:

Dimension the array as a type other than Variant. For example, dimension the array as type String.

-or-
Pass the element of the array by value.

-or -
Use a temporary variable to store and retrieve the value of the array element. For example, this code uses a variable "temp" to store and retrieve the value of the first element of "myarray":
```
     temp = myarray(1)
     MyObject.MyMethod temp
     myarray(1) = temp

						
```

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This bug has been fixed in Visual Basic 6.0.

MORE INFORMATION

Steps to Reproduce Behavior

Start a new Standard EXE project.
Click Components on the Project menu, and then check "Microsoft Databound Grid Control."
Draw a dbGrid control and CommandButton on Form1.

Add the following code to Form1:

      Dim o As Object

      Private Sub Command1_Click()
         test
      End Sub

      Private Sub test()
         Set o = New Class1
         ReDim myarray(1) As Variant
         o.MyMethod myarray(1)
      End Sub

Click Add Class Module on the Project menu.

Add the following code to Class1:

      Public Sub MyMethod(x As Variant)

      End Sub

Make the EXE and then run the EXE. Click Command1 and note that you receive the run-time error #10 and the application will quit.

Modification Type:	Minor	Last Reviewed:	8/11/2005
Keywords:	kbbug kbfix kbGrpDSVB KB176049 kbAudDeveloper