Click here to Skip to main content
16,011,647 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: MDI MFC application: being able to run it windowless Pin
User 988520-Nov-02 7:48
User 988520-Nov-02 7:48 
GeneralRe: MDI MFC application: being able to run it windowless Pin
User 988520-Nov-02 8:00
User 988520-Nov-02 8:00 
GeneralRe: MDI MFC application: being able to run it windowless Pin
Maximilien20-Nov-02 7:04
Maximilien20-Nov-02 7:04 
GeneralCStatusBar Document/View Pin
gandalf337320-Nov-02 5:49
gandalf337320-Nov-02 5:49 
GeneralRe: CStatusBar Document/View Pin
RobJones20-Nov-02 7:15
RobJones20-Nov-02 7:15 
GeneralDAO SDK Pin
dan o20-Nov-02 5:28
dan o20-Nov-02 5:28 
GeneralThe Large Access Database ! Pin
Hadi Rezaee20-Nov-02 5:23
Hadi Rezaee20-Nov-02 5:23 
GeneralRe: The Large Access Database ! Pin
dan o20-Nov-02 5:40
dan o20-Nov-02 5:40 
hi,

it depends what you want, (do you need all records)

do you use requery (views) or access direct to your tables

if you use tables normally you could go for something like

CTableNumbers tableNumbers

tableNumbers.Open()

or

CString strSQL;
strSQL = "SELECT * FROM [Numbers] WHERE Number > 10000 ORDER BY Number ASC";

TRY
{
tableNumbers.Open(AFX_DAO_USE_DEFAULT_TYPE, strSQL)

//do something

tableNumbers.Close()

}
CATCH( CDaoException, error )
{
//do handle your error
}
END_CATCH

but access is slow anyway,
you could think about opening the database tables at startup of your programm and of course at the closing your app close the database also

hope it helps,

GeneralRe: The Large Access Database ! Pin
Hadi Rezaee20-Nov-02 6:21
Hadi Rezaee20-Nov-02 6:21 
GeneralRe: The Large Access Database ! Pin
Christian Graus20-Nov-02 6:52
protectorChristian Graus20-Nov-02 6:52 
GeneralRe: The Large Access Database ! Pin
Hadi Rezaee20-Nov-02 8:15
Hadi Rezaee20-Nov-02 8:15 
GeneralRe: The Large Access Database ! Pin
Christian Graus20-Nov-02 8:21
protectorChristian Graus20-Nov-02 8:21 
GeneralRe: The Large Access Database ! Pin
Hadi Rezaee20-Nov-02 10:15
Hadi Rezaee20-Nov-02 10:15 
GeneralClipboard Question Pin
Nitron20-Nov-02 5:05
Nitron20-Nov-02 5:05 
GeneralRe: Clipboard Question Pin
User 988520-Nov-02 5:17
User 988520-Nov-02 5:17 
GeneralRe: Clipboard Question Pin
Nitron20-Nov-02 8:00
Nitron20-Nov-02 8:00 
GeneralRe: Clipboard Question Pin
User 988520-Nov-02 8:10
User 988520-Nov-02 8:10 
GeneralRe: Clipboard Question Pin
Nitron20-Nov-02 8:13
Nitron20-Nov-02 8:13 
GeneralRe: Clipboard Question Pin
User 988520-Nov-02 8:53
User 988520-Nov-02 8:53 
GeneralMemory Problems!!! Pin
Paddy20-Nov-02 5:04
Paddy20-Nov-02 5:04 
GeneralRe: Memory Problems!!! Pin
Rickard Andersson2020-Nov-02 5:11
Rickard Andersson2020-Nov-02 5:11 
GeneralRe: Memory Problems!!! Pin
Paddy20-Nov-02 6:43
Paddy20-Nov-02 6:43 
GeneralRe: Memory Problems!!! Pin
Nitron20-Nov-02 5:11
Nitron20-Nov-02 5:11 
GeneralRe: Memory Problems!!! Pin
Paddy20-Nov-02 6:44
Paddy20-Nov-02 6:44 
GeneralRe: Memory Problems!!! Pin
Nitron20-Nov-02 6:52
Nitron20-Nov-02 6:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.