Click here to Skip to main content
15,940,550 members
Home / Discussions / Database
   

Database

 
GeneralRe: Handling of Fetched Records Pin
David Salter23-Aug-04 3:03
David Salter23-Aug-04 3:03 
GeneralRe: Handling of Fetched Records Pin
pry50423-Aug-04 4:38
pry50423-Aug-04 4:38 
GeneralCompiler Error Pin
#realJSOP22-Aug-04 12:33
professional#realJSOP22-Aug-04 12:33 
GeneralRe: Compiler Error Pin
S Sansanwal22-Aug-04 13:41
S Sansanwal22-Aug-04 13:41 
GeneralRe: Compiler Error Pin
#realJSOP22-Aug-04 23:33
professional#realJSOP22-Aug-04 23:33 
GeneralDatagrid data refresh problem Pin
lkreuzer22-Aug-04 7:17
lkreuzer22-Aug-04 7:17 
GeneralDataColumn question Pin
blankg22-Aug-04 6:47
blankg22-Aug-04 6:47 
GeneralADO + SQL statements Pin
#realJSOP22-Aug-04 6:01
professional#realJSOP22-Aug-04 6:01 
(Using VC++ 6.0 - I will not use .NET for this project, so don't bother suggesting it)

I want to have as little impact on the user's installation requirements as possible. In other words, I only want them to have to install my app and maybe a newer version of MDAC, but nothing more.

I'm pretty new to this database stuff. (I think) I want to use an Access97 data source, and I need to be able to create the database programmatically (including keys, indexes, and relationships) because the file won't be there when the app is intitially executed.

It's going to be a fairly small database with 7-10 tables and the largest table will have under 2250 records (worst case).

Is ADO a good choice? I'm planning to make use of Carlos Antollini's ADO class article.

Can someone recommend a decent book that covers both ADO and SQL?

Any other suggestions (not including the use of .NET) are welcomed.



------- sig starts

"I've heard some drivers saying, 'We're going too fast here...'. If you're not here to race, go the hell home - don't come here and grumble about going too fast. Why don't you tie a kerosene rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt

"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
GeneralRe: ADO + SQL statements Pin
Christian Graus22-Aug-04 15:19
protectorChristian Graus22-Aug-04 15:19 
GeneralRe: ADO + SQL statements Pin
#realJSOP22-Aug-04 23:35
professional#realJSOP22-Aug-04 23:35 
GeneralRe: ADO + SQL statements Pin
Christian Graus23-Aug-04 10:23
protectorChristian Graus23-Aug-04 10:23 
GeneralRe: ADO + SQL statements Pin
Ryan Roberts23-Aug-04 4:44
Ryan Roberts23-Aug-04 4:44 
GeneralRe: ADO + SQL statements Pin
J. Vorstenbosch25-Aug-04 0:40
J. Vorstenbosch25-Aug-04 0:40 
GeneralAuto date colum Pin
Zee_Zee21-Aug-04 1:55
Zee_Zee21-Aug-04 1:55 
GeneralRe: Auto date colum Pin
David Salter22-Aug-04 11:43
David Salter22-Aug-04 11:43 
GeneralSQL database problem Pin
Chodici Mrkev20-Aug-04 4:04
Chodici Mrkev20-Aug-04 4:04 
GeneralRe: SQL database problem Pin
Colin Angus Mackay20-Aug-04 4:49
Colin Angus Mackay20-Aug-04 4:49 
GeneralRe: SQL database problem Pin
Chodici Mrkev20-Aug-04 6:09
Chodici Mrkev20-Aug-04 6:09 
GeneralRe: SQL database problem Pin
Colin Angus Mackay20-Aug-04 6:26
Colin Angus Mackay20-Aug-04 6:26 
GeneralRe: SQL database problem Pin
Chodici Mrkev20-Aug-04 7:33
Chodici Mrkev20-Aug-04 7:33 
GeneralRe: SQL database problem Pin
Colin Angus Mackay20-Aug-04 7:54
Colin Angus Mackay20-Aug-04 7:54 
GeneralRe: SQL database problem Pin
Steven Campbell20-Aug-04 7:42
Steven Campbell20-Aug-04 7:42 
GeneralRe: SQL database problem Pin
Colin Angus Mackay20-Aug-04 7:55
Colin Angus Mackay20-Aug-04 7:55 
GeneralRe: SQL database problem Pin
Christian Graus22-Aug-04 15:30
protectorChristian Graus22-Aug-04 15:30 
GeneralRe: SQL database problem Pin
Colin Angus Mackay23-Aug-04 4:12
Colin Angus Mackay23-Aug-04 4:12 

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.