Run time error '2004'

[Tommy408]

When I run this code:
DoCmd.OpenForm "Contacts", , , "[ID] =" & Me.ID, acFormEdit, acWindowNormal

I keep getting the Run time error '2004'
"There isn't enough memmory to perform this operation. Close uneeded programs and try this operation again."

I have 1 gig of memory, rebooted, run the code again, same error. I'm using Windows 2000 pro with SP4.

And I just found out I can't edit or open the form "Contacts" with mouse click. It said there isn't enough memory to perform this operation.

 

[PHV]

Have you tried to compact and repair the DB ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886