AdamVerellen
IS-IT--Management
I'm using DAO 3.6
I get a memory problem when running the following select statement. It works before compiling. After compile I get the memory error. I can provide more info if someone has an idea.
Set LabelList = DB.OpenRecordset("Select * from [Work In Progress] where sequence between " & Partno1 & " AND " & Partno2 & " order by sequence",dbOpenSnapShot)
There is only about 50 records ever selected. I can't understand why it works before compiling but not after.
I have all the latest service packs installed.
I'm open to suggestions.
I get a memory problem when running the following select statement. It works before compiling. After compile I get the memory error. I can provide more info if someone has an idea.
Set LabelList = DB.OpenRecordset("Select * from [Work In Progress] where sequence between " & Partno1 & " AND " & Partno2 & " order by sequence",dbOpenSnapShot)
There is only about 50 records ever selected. I can't understand why it works before compiling but not after.
I have all the latest service packs installed.
I'm open to suggestions.
