Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Maximum number of queries that hit the table
- Thread starter 3728
- Start date
No, it isn't. Maybe you open databases and/or recordsets on your VBA code? In this case always you may close these and set those as Nothing
private sub abc
dim rst as recordset
dim dbs as database
Set dbs = DBEngine.Workspaces(0).OpenDatabase("c:\DB.mdb"
...........
...........
set rst=dbs.openrecordset("MyTable"
...........
...........
rst.close
set rst=nothing
dbs.close
set dbs=nothing
end sub
I'm not sure that it will help you, but I don't meet messages about memory after I began use code above.
Aivars
private sub abc
dim rst as recordset
dim dbs as database
Set dbs = DBEngine.Workspaces(0).OpenDatabase("c:\DB.mdb"
...........
...........
set rst=dbs.openrecordset("MyTable"
...........
...........
rst.close
set rst=nothing
dbs.close
set dbs=nothing
end sub
I'm not sure that it will help you, but I don't meet messages about memory after I began use code above.
Aivars
- Status
Similar threads
- Locked
- Question
- Locked
- Question