microsoft.public.vb.database.ado

Date Index

Problems displaying Unicode data using the Datagrid 6.0 (VB6), Marmaire
Error in SELECT INTO in dbase tables, boris
Can you "fake out" having a primary key on a data table?, JohnR
Recordset, Ellie
A NEW challenge to crop images in Visual Basic 6 by Trilok, bajpai
- RE: A NEW challenge to crop images in Visual Basic 6 by Trilok, Mario G.
Disconnected Recordsets & Events, Mario G.
updating an sqlserver dataset bound to textbox controls, mikeg
error 3021 error handling, pb
- RE: error 3021 error handling, Mario G.
  - RE: error 3021 error handling, pb
What is connection string after I change protocol to connect to SQL Server? - using Named Pipes; was TCP/IP, L Mehl
Recordset query?, William Barnes
- Re: Recordset query?, brijeshmathew
  - Re: Recordset query?, William Barnes
- Re: Recordset query?, Adrian Moore
  - Re: Recordset query?, William Barnes
    - Re: Recordset query?, Ellie
Problem: Programmatically adding/deleting Access table indexes, Sheryl Weisser
- Re: Problem: Programmatically adding/deleting Access table indexes, Gijs Beukenoot
  - Re: Problem: Programmatically adding/deleting Access table indexes, Sheryl Weisser
    - Re: Problem: Programmatically adding/deleting Access table indexes, Gijs Beukenoot
ADO and SEEK crash (VB6), Ree
Cannot generate SSPI context; SQLServer 2000/MgtConsole SP3, VB6, L Mehl
- Re: Cannot generate SSPI context; SQLServer 2000/MgtConsole SP3, VB6, Douglas J. Steele
  - Re: Cannot generate SSPI context; SQLServer 2000/MgtConsole SP3, VB6, L Mehl
Question concerning Select vs Find, jimcolli
- Re: Question concerning Select vs Find, JimC
Connecting To An Access Database, Thomas Kerr
- Re: Connecting To An Access Database, Winguy
  - Re: Connecting To An Access Database, Thomas Kerr
    - Re: Connecting To An Access Database, Paul Clement
Deleting from datagrid, Ian Davies
- Re: Deleting from datagrid, Mark J. McGinty
VB6 Data Environment table problem, Winguy
- Re: VB6 Data Environment table problem, Ralph
  - Re: VB6 Data Environment table problem, Winguy
    - Re: VB6 Data Environment table problem, Winguy
SELECT in partitions, LUIS
Can't read DBF file with VFPOLEDB driver? But can with ODBC., Darrell Wesley
- Re: Can't read DBF file with VFPOLEDB driver? But can with ODBC., Ralph
  - Re: Can't read DBF file with VFPOLEDB driver? But can with ODBC., Darrell Wesley
    - Re: Can't read DBF file with VFPOLEDB driver? But can with ODBC., Cindy Winegarden
    - Re: Can't read DBF file with VFPOLEDB driver? But can with ODBC., Cindy Winegarden
    - Re: Can't read DBF file with VFPOLEDB driver? But can with ODBC., Darrell Wesley
    - Re: Can't read DBF file with VFPOLEDB driver? But can with ODBC., Cindy Winegarden
Best way to update a record, smk23
- Re: Best way to update a record, boaz
- Re: Best way to update a record, Paul Clement
- Re: Best way to update a record, Val Mazur \(MVP\)
- Re: Best way to update a record, Val Mazur \(MVP\)
MDAC 2.8 Issues?, jamesfreddyc
- Re: MDAC 2.8 Issues?, Ralph
  - Re: MDAC 2.8 Issues?, jamesfreddyc
    - Re: MDAC 2.8 Issues?, Ralph
Using SQL CASE Statement with Access, Bill
- Re: Using SQL CASE Statement with Access, Paul Clement
  - Re: Using SQL CASE Statement with Access, Bill
Date delimiter, Martin
- Re: Date delimiter, Paul Clement
JET ODBC Driver Error In XP SP2, boaz
- Re: JET ODBC Driver Error In XP SP2, Paul Clement
  - Re: JET ODBC Driver Error In XP SP2, boaz
    - Re: JET ODBC Driver Error In XP SP2, Paul Clement
    - Re: JET ODBC Driver Error In XP SP2, boaz
    - Re: JET ODBC Driver Error In XP SP2, Paul Clement
MS JET database engine error: workgroup information file is missing or opened exclusively by another user, Tina
ADO Error in XP, boaz
Check database structure, JD
- Re: Check database structure, brijeshmathew
  - Re: Check database structure, JD
- Re: Check database structure, Ronald Roberts
  - Re: Check database structure, JD
Deleting a Constraint, JD
- Re: Deleting a Constraint, Paul Clement
  - Re: Deleting a Constraint, JD
Empty recordset at asynchronous execution, Ralf Leippert
- Re: Empty recordset at asynchronous execution, Paul Clement
  - Re: Empty recordset at asynchronous execution, Ralf Leippert
Really disconnect a recordset?, Mike Jansen
How to export data from Excel to Access2000 by using ADO ?, chen
- Re: How to export data from Excel to Access2000 by using ADO ?, Paul Clement
  - Re: How to export data from Excel to Access2000 by using ADO ?, chen
how to speed up database processing?, pb
ADO numeric formatting problem, dave
wanted: select query with has no result but with columns in record, Jan
- Re: wanted: select query with has no result but with columns in record, Max Kudrenko
  - Re: wanted: select query with has no result but with columns in re, Jan
    - Re: wanted: select query with has no result but with columns in re, Max Kudrenko
- Re: wanted: select query with has no result but with columns in record, Ch. Marx
- Re: wanted: select query with has no result but with columns in record, Mark J. McGinty
Saving picture to a database, Bruce Baker
- Re: Saving picture to a database, Martin
- Re: Saving picture to a database, Paul Clement
Query using different data source - Is it possible?, totoro9
- Re: Query using different data source - Is it possible?, Paul Clement
ADO CommitTrans error trap, Scott Meloney
CursorType Error on Stored Procedure - AbsolutePage Property, Nick
- HELP! Error on Stored Procedure - AbsolutePage Property, Nick
  - Re: HELP! Error on Stored Procedure - AbsolutePage Property, Paul Clement
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, Nick
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, William \(Bill\) Vaughn
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, Nick
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, William \(Bill\) Vaughn
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, Nick
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, Someone
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, Someone
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, Nick
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, Paul Clement
    - Re: HELP! Error on Stored Procedure - AbsolutePage Property, Mark J. McGinty
RE: Viewing name of roles created by user ?, whidbey_boy
Trapping CommitTrans - returns success even when failed!, Scott M
Invalid setting in Excel key of the Engines section of the Windows Registry, Bruce H
Column 'Q787P18' is not found. ( FoxPro Table), Darrell Wesley
- Re: Column 'Q787P18' is not found. ( FoxPro Table), Cindy Winegarden
  - Re: Column 'Q787P18' is not found. ( FoxPro Table), Darrell Wesley
    - Re: Column 'Q787P18' is not found. ( FoxPro Table), Cindy Winegarden
    - Re: Column 'Q787P18' is not found. ( FoxPro Table), Darrell Wesley
    - Re: Column 'Q787P18' is not found. ( FoxPro Table), Cindy Winegarden
  - Re: Column 'Q787P18' is not found. ( FoxPro Table), Darrell Wesley
    - Re: Column 'Q787P18' is not found. ( FoxPro Table), Cindy Winegarden
Repost: MaskedEdit and Databinding, Michael Tooth
- Re: Repost: MaskedEdit and Databinding, Someone
Datagrid and Select query with Join, phuile
- Re: Datagrid and Select query with Join, Earl
  - Errata, Earl
help with VB comparing SQL field and AD attribute, Mobzilla
- RE: help with VB comparing SQL field and AD attribute, Kevin Yu [MSFT]
  - RE: help with VB comparing SQL field and AD attribute, Mobzilla
    - RE: help with VB comparing SQL field and AD attribute, Kevin Yu [MSFT]
Problem writing to newly created table & field., Jennifer W
- Re: Problem writing to newly created table & field., Someone
- Re: Problem writing to newly created table & field., Ralph
  - Re: Problem writing to newly created table & field., Jennifer W
ADO to connect to Excel Worksheet - ERROR, Russell Hauf
- Re: ADO to connect to Excel Worksheet - ERROR, Paul Clement
  - Re: ADO to connect to Excel Worksheet - ERROR, Russell Hauf
    - Re: ADO to connect to Excel Worksheet - ERROR, Paul Clement
    - Re: ADO to connect to Excel Worksheet - ERROR, Russell Hauf
Re: DB2, MsSQL, and MS Access, How to maintain 3 data sources, Jorge Jimenez
can not connect to the MS Access database mdb, Curie
- Re: can not connect to the MS Access database mdb, Veign
  - Re: can not connect to the MS Access database mdb, Curie
- Re: can not connect to the MS Access database mdb, boaz
  - Re: can not connect to the MS Access database mdb, Curie
Modify crosstab query via VBA, SusanV
autonumber, Dan P
- Re: autonumber, Veign
  - Re: autonumber, Dan P
    - Re: autonumber, Veign
need help with sql query, pb
- Re: need help with sql query, Earl
- Re: need help with sql query, Val Mazur \(MVP\)
  - Re: need help with sql query, pb
    - Re: need help with sql query, Earl
    - Re: need help with sql query, pb
    - Re: need help with sql query, JoeO
    - Re: need help with sql query, Earl
- RE: need help with sql query, pb
"Could not determine which columns uniquely identify the rows for tablename", sf2005
- Re: "Could not determine which columns uniquely identify the rows for tablename", Earl
DateDiff Sql query not working, pb
- Re: DateDiff Sql query not working, JoeO
DataBinding objects and Updating, Michael Tooth
XP ODBC Drvier Problem, boaz
- Re: XP ODBC Drvier Problem, boaz
  - Re: XP ODBC Drvier Problem, Kevin Morix
    - Re: XP ODBC Drvier Problem, boaz
How can I trap an error on a "CommitTrans" command in VB6 using ADO and SQL Server 2000?, William Hildebrand
- Re: How can I trap an error on a "CommitTrans" command in VB6 using ADO and SQL Server 2000?, Ralph
ADOrs from Oracle StoredProc. Cannot *correctly* pass params into db., jamesfreddyc
- Re: ADOrs from Oracle StoredProc. Cannot *correctly* pass params into db., Paul Clement
  - Re: ADOrs from Oracle StoredProc. Cannot *correctly* pass params into db., jamesfreddyc
  - Re: ADOrs from Oracle StoredProc. Cannot *correctly* pass params into db., jamesfreddyc
  - Any suggestions with this updated code????, jamesfreddyc
    - Re: Any suggestions with this updated code????, Paul Clement
    - Re: Any suggestions with this updated code????, jamesfreddyc
    - Re: Any suggestions with this updated code????, Paul Clement
    - Re: Any suggestions with this updated code????, jamesfreddyc
    - Re: Any suggestions with this updated code????, Paul Clement
    - Re: Any suggestions with this updated code????, jamesfreddyc
    - Re: Any suggestions with this updated code????, Paul Clement
    - Re: Any suggestions with this updated code????, jamesfreddyc
    - Re: Any suggestions with this updated code????, Paul Clement
    - Re: Any suggestions with this updated code????, jamesfreddyc
Mutlilanguage and Oracle 9.2 , VB6, weetat
Re: Insert related, Thomas R. Moore
- Re: Insert related, Earl
  - Re: Insert related, Thomas R. Moore
    - Re: Insert related, Earl
master details, Pure Heart
- Re: master details, Ralph
Error on implementing .Properties("AutoIncrement") = True, Brandon
- Re: Error on implementing .Properties("AutoIncrement") = True, Douglas J. Steele
  - Re: Error on implementing .Properties("AutoIncrement") = True, Brandon
    - Re: Error on implementing .Properties("AutoIncrement") = True, Douglas J. Steele
run time error 91 when using data control, greythej
- Message not available
  - Re: run time error 91 when using data control, greythej
Currency calculation problems in VB6 and Access 2K, steve
- Re: Currency calculation problems in VB6 and Access 2K, Earl
ExecuteReade problem, really really stuck!, venAdder
- Re: ExecuteReade problem, really really stuck!, Ralph
Trouble passing a numeric data type, Ellie
- Re: Trouble passing a numeric data type, Val Mazur \(MVP\)
  - Re: Trouble passing a numeric data type, Ellie
Using ADODB.Connection Execute and commit, Peter
- Re: Using ADODB.Connection Execute and commit, Val Mazur \(MVP\)
  - Re: Using ADODB.Connection Execute and commit, Al Reid
    - Re: Using ADODB.Connection Execute and commit, Peter
    - Re: Using ADODB.Connection Execute and commit, Al Reid
    - Re: Using ADODB.Connection Execute and commit, Peter
    - Re: Using ADODB.Connection Execute and commit, Al Reid
    - Re: Using ADODB.Connection Execute and commit, Peter
    - Re: Using ADODB.Connection Execute and commit, Val Mazur \(MVP\)
vb.net and MS Access make table query, Bob
- Re: vb.net and MS Access make table query, Paul Clement
How to export a subset of data from a dataset., David Richards
- Re: How to export a subset of data from a dataset., Ralph
Access Linked table to db3 problem, mlc
HowTO: append.fields, Ray
- Re: HowTO: append.fields, Val Mazur \(MVP\)
  - Re: HowTO: append.fields, Ray
    - some success, Ray
    - Re: some success, Al Reid
    - Re: HowTO: append.fields, Paul Clement
- Thanks, Ray
Using Rollup with Oracle Hierarchical Query ?, Luqman
SetPermissions and ADO 2.8, Dave
- RE: SetPermissions and ADO 2.8, Dave
Installing MDAC 2.7 and JET 4.0, boaz
- Re: Installing MDAC 2.7 and JET 4.0, Val Mazur \(MVP\)
  - Re: Installing MDAC 2.7 and JET 4.0, bz
    - Re: Installing MDAC 2.7 and JET 4.0, Val Mazur \(MVP\)
    - Re: Installing MDAC 2.7 and JET 4.0, boaz
    - Re: Installing MDAC 2.7 and JET 4.0, Val Mazur \(MVP\)
Questions about ADO 2.8, Dave
- Re: Questions about ADO 2.8, Ralph
- Re: Questions about ADO 2.8, boaz
  - Re: Questions about ADO 2.8, Dave
Trouble with NULL being read into Column(x), WB
- Re: Trouble with NULL being read into Column(x), Veign
  - Re: Trouble with NULL being read into Column(x), WB
Re: ado connection to access, Alberto Covili
Insert binary file content to DB, quest
- Re: Insert binary file content to DB, Ralph
  - Re: Insert binary file content to DB, quest
    - Re: Insert binary file content to DB, Ralph
    - Re: Insert binary file content to DB, Paul Clement
TOP Predicate makes a query readonly???, Martin
- Re: TOP Predicate makes a query readonly???, Tom Moreau
  - Re: TOP Predicate makes a query readonly???, Martin
    - Re: TOP Predicate makes a query readonly???, Tom Moreau
- Re: TOP Predicate makes a query readonly???, William \(Bill\) Vaughn
BatchUpdate with ADO, adoMain
- Re: BatchUpdate with ADO, Terry Kreft
DataGrid - how detect a change in any field in 1 row, and then update table? VB6, SQL 2000, L Mehl
- Re: DataGrid - how detect a change in any field in 1 row, and then update table? VB6, SQL 2000, Mark J. McGinty
  - Re: DataGrid - how detect a change in any field in 1 row, and then update table? VB6, SQL 2000, L Mehl
who to know the kind of data i'm storing in a adodb.recordset, PERRO
- Re: who to know the kind of data i'm storing in a adodb.recordset, Al Reid
- Re: who to know the kind of data i'm storing in a adodb.recordset, Paul Clement
WatchDog Timer, boaz
- Re: WatchDog Timer, Ralph
  - Re: WatchDog Timer, boaz
    - Re: WatchDog Timer, William \(Bill\) Vaughn
    - Re: WatchDog Timer, Jennifer W
Link Oracle Tables to Access using VBA, ADO and ADOX, Holger Velte
- Re: Link Oracle Tables to Access using VBA, ADO and ADOX, Ralph
  - Re: Link Oracle Tables to Access using VBA, ADO and ADOX, Holger Velte
    - Re: Link Oracle Tables to Access using VBA, ADO and ADOX, Ralph
    - Re: Link Oracle Tables to Access using VBA, ADO and ADOX, Ralph
- Re: Link Oracle Tables to Access using VBA, ADO and ADOX, Paul Clement
  - Re: Link Oracle Tables to Access using VBA, ADO and ADOX, Ralph
How to trap Network failure or Database failure while VB applicati, mukesh
- Re: How to trap Network failure or Database failure while VB applicati, Ralph
  - Re: How to trap Network failure or Database failure while VB appli, mukesh
delete issues with ado, inzo
- Re: delete issues with ado, Veign
  - Re: delete issues with ado, inzo
    - Re: delete issues with ado, Veign
How To Change FieldSize Using ADO, Martin
- Re: How To Change FieldSize Using ADO, Veign
Error in calling stored procedure via DB link, Deva
- Re: Error in calling stored procedure via DB link, Paul Clement
  - Re: Error in calling stored procedure via DB link, Deva
    - Re: Error in calling stored procedure via DB link, Paul Clement
    - Re: Error in calling stored procedure via DB link, Deva
Adodb.Recordset Async query in vb6 and xp - IDE Vanishes, info_Seeker77
Optimistic Concurrency - DataRow Column Errors Not Set, CPatrick_530
- Re: Optimistic Concurrency - DataRow Column Errors Not Set, Ralph
Will adLockBatchOptimistic allow batch updates on client-side cursors?, D Babin
Re: SQL Navigator, timothy . somero
VB query question, Claudia Fong
- Re: VB query question, Ian Davies
slick way to search all fields in one table for a string, mcnewsxp
Re: Auto refresh data in datagrid with ADO, boaz
adodc_Validate(action As Integer, save As Integer) fails to fire, sait
- RE: adodc_Validate(action As Integer, save As Integer) fails to fire, sait
  - RE: adodc_Validate(action As Integer, save As Integer) fails to fire, Steven Cheng[MSFT]
    - RE: adodc_Validate(action As Integer, save As Integer) fails to fi, sait
Problem Accessing MSYSOBJECTS table, Dave
- RE: Problem Accessing MSYSOBJECTS table, Dave
  - Re: Problem Accessing MSYSOBJECTS table, Paul Clement
- Re: Problem Accessing MSYSOBJECTS table, Paul Clement
  - Re: Problem Accessing MSYSOBJECTS table, Dave
    - Re: Problem Accessing MSYSOBJECTS table, Paul Clement
Thanks for the feedback, Kahuna
create a report in VB instead of creating in Ms-Access, Claudia Fong
- Re: create a report in VB instead of creating in Ms-Access, Ralph
Re: BETWEEN statement, William \(Bill\) Vaughn
- Re: BETWEEN statement, Darrell Wesley
  - Re: BETWEEN statement, William \(Bill\) Vaughn
  - Re: BETWEEN statement, Ralph
- <Possible follow-ups>
- Re: BETWEEN statement, boaz
Re: Syntax for multiple WHERE in recordset? - Sorry Folks Originally Posted in Wrong Group (Controls), argusy
- <Possible follow-ups>
- Re: Syntax for multiple WHERE in recordset? - Sorry Folks Originally Posted in Wrong Group (Controls), William \(Bill\) Vaughn
  - Re: Syntax for multiple WHERE in recordset? - Sorry Folks Originally Posted in Wrong Group (Controls), argusy
  - Re: Syntax for multiple WHERE in recordset? - Sorry Folks Originally Posted in Wrong Group (Controls), Paul Clement
- Re: Syntax for multiple WHERE in recordset? - Sorry Folks Originally Posted in Wrong Group (Controls), Kahuna