Out of Memory

[rssmith@up.com]

What are some reasons why ACCESS 97 would display "Out of Memory" errors when I run my macros and try to open a linked table?

 

[Mile-O]

From MS Knowledge base

 

[alexbri]

If you're using recordsets and db connections, are you closing them at the end of your macros...

 

[rssmith@up.com]

Out of Memory - Answer to Question

If you're using recordsets and db connections, are you closing them at the end of your macros...

No, what do you recommend?

 

[Mile-O]

If you are using code like:

Dim db As DAO.Database
Dim rs As DAO.Recordset

or

Dim cn As ADODB.Connection
Dim rs As New ADODB.Recordset

then remember to set the object variable defined to nothing once its usage is complete

i.e.

Set db = Nothing