RUN TIME ERROR 3035 System Resource Exceeded

B

BlueWolverine

Hello, Running MS Access 2003 on XP Pro.

I just ran code that has always worked and got Run time error 3035: System
resource exceeded.

I just added 3GB of RAM to this machine. It always worked on 1GB but now it
won't work on 4GB??

Any clues?

Thanks.
 
B

BlueWolverine

Here is the code that the problem occurs on. <<<>>> indicates line where
error pops.

Private Sub cmd_SearchSpecific_Click()
Dim mydb As Database, rs As DAO.Recordset, tqn As String, parm As
DAO.Parameter, qdf As QueryDef
Set mydb = CurrentDb
tqn = "q_search_exact"
Set qdf = mydb.QueryDefs(tqn)

<<< For Each parm In qdf.Parameters >>>
parm.Value = Eval(parm.Name)
Next parm
Set rs = qdf.OpenRecordset


If rs.EOF Or rs.BOF Then
DoCmd.Beep
MsgBox "Returned zero (0) results.", vbOKOnly, "Search Complete"
Else
DoCmd.OpenForm "f_search_exact", acNormal
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top