RUN TIME ERROR 3035 System Resource Exceeded

  • Thread starter Thread starter BlueWolverine
  • Start date Start date
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.
 
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

Back
Top