Click here to Skip to main content
15,925,255 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Database Problem Pin
Mike Nordell11-Jul-02 1:40
Mike Nordell11-Jul-02 1:40 
GeneralRe: Database Problem Pin
Martin Ziacek11-Jul-02 8:18
Martin Ziacek11-Jul-02 8:18 
GeneralRe: Database Problem Pin
Christian Graus10-Jul-02 4:36
protectorChristian Graus10-Jul-02 4:36 
GeneralRe: Database Problem Pin
BHBAD10-Jul-02 4:39
sussBHBAD10-Jul-02 4:39 
GeneralRe: Database Problem Pin
Carlos Antollini10-Jul-02 4:57
Carlos Antollini10-Jul-02 4:57 
GeneralRe: Database Problem Pin
Michael P Butler10-Jul-02 4:38
Michael P Butler10-Jul-02 4:38 
GeneralRe: Database Problem Pin
Brian Azzopardi10-Jul-02 4:50
Brian Azzopardi10-Jul-02 4:50 
GeneralRe: Database Problem Pin
Matt Gullett10-Jul-02 4:47
Matt Gullett10-Jul-02 4:47 
As far as stand-alone databases MS Access is probably you're best bet. Unfortunantely, there is a 2gb limit.

One idea: split the DB into multiple MDB files and LINK the tables into a master database. Basically with this configuration you can still have a single view of the DB but have the data from the various tables spread out. This will not work, though, if you have 1 table that exceeds your 2gb limit.

Another idea: most access databases are not designed well (I'm not saying yours is poorly designed, just that this is what i've seen.) You should look at the size of the columns in your tables and see if they can be shrunk. Many DB's I've seen use the default size for text columns which is 50 characters. Often this leaves alot of unused space. Also, look for redundant data and consider normalizing the database a little. (Normalizing has the unfortunante side effect of causing you to modify your code, though.)
GeneralPM_QS_PAINT question. Pin
Michael Liu10-Jul-02 3:54
Michael Liu10-Jul-02 3:54 
GeneralRe: PM_QS_PAINT question. Pin
Christian Graus10-Jul-02 4:02
protectorChristian Graus10-Jul-02 4:02 
GeneralRe: PM_QS_PAINT question. Pin
Michael Liu10-Jul-02 4:18
Michael Liu10-Jul-02 4:18 
GeneralRe: PM_QS_PAINT question. Pin
Christian Graus10-Jul-02 4:31
protectorChristian Graus10-Jul-02 4:31 
GeneralRe: PM_QS_PAINT question. Pin
Michael Liu10-Jul-02 4:50
Michael Liu10-Jul-02 4:50 
GeneralRe: PM_QS_PAINT question. Pin
Michael Liu10-Jul-02 7:24
Michael Liu10-Jul-02 7:24 
GeneralRe: PM_QS_PAINT question. Pin
Christian Graus10-Jul-02 11:36
protectorChristian Graus10-Jul-02 11:36 
GeneralRe: PM_QS_PAINT question. Pin
Michael P Butler10-Jul-02 4:40
Michael P Butler10-Jul-02 4:40 
GeneralRe: PM_QS_PAINT question. Pin
Michael Liu10-Jul-02 4:50
Michael Liu10-Jul-02 4:50 
GeneralRe: PM_QS_PAINT question. Pin
Michael P Butler10-Jul-02 4:56
Michael P Butler10-Jul-02 4:56 
GeneralRe: PM_QS_PAINT question. Pin
Michael Liu10-Jul-02 5:00
Michael Liu10-Jul-02 5:00 
GeneralRe: PM_QS_PAINT question. Pin
Michael Liu10-Jul-02 6:03
Michael Liu10-Jul-02 6:03 
GeneralEDIT - load & save text. Pin
peterchen10-Jul-02 3:28
peterchen10-Jul-02 3:28 
Generalsetting focus to an editbox on a modal dlg, when the dlg is spawned Pin
ns10-Jul-02 3:13
ns10-Jul-02 3:13 
GeneralRe: setting focus to an editbox on a modal dlg, when the dlg is spawned Pin
peterchen10-Jul-02 3:30
peterchen10-Jul-02 3:30 
GeneralWow! Thanks a million! SetFocus() works! Pin
ns10-Jul-02 3:45
ns10-Jul-02 3:45 
GeneralGetting the process listening on a specific TCP port Pin
Thomas Freudenberg10-Jul-02 2:55
Thomas Freudenberg10-Jul-02 2:55 

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.