Article List for VB 3.0: Data Access with Microsoft Access/Jet

The information in this article applies to:

• FastTips for Microsoft Visual Basic for Windows, version 3.0

INSTRUCTION

Microsoft FastTips is available 24 hours a day, 7 days a week, from a touch-tone telephone. To order items from this catalog, first select the items you want to receive, noting the five- to six-digit number of the Item ID shown below for each item, and then:

- Dial the toll-free FastTips number (800) 936-4300. - When prompted, select Microsoft Visual Basic. - Press one (1) on your phone keypad to select Express Order Service. - When prompted, select the delivery method, fax. - When prompted, enter your three-digit area code and seven-digit fax

  number on your phone keypad.

  to five items.

ARTICLE LISTING

ITEM ID  ARTICLE TITLE                                               PAGES

Q 97181  How to Keep the Current Record the Same After Using Refresh     2
Q 97413  How to Copy Current Database Record into a Record Variable      4
Q 97414  How to Use Data Control to Scroll Up and Down in a Recordset    3
Q 99704  How to Implement the DLookup Function in Visual Basic           3
Q 101553 BUG: Bad Result If Multiple Aggregate Functions in SQL Stmt     2

Q 102479 BUG: Domain Functions Available Only Within SQL Statement       2
Q 102481 UPD: New Access Engine MSAJT110.DLL Available                   1
Q 102681 PRB: Error When Updating Fields in Dynaset That Has 2+ Tables   2
Q 103442 Differences Between the Object Variables in VB Version 3.0      4
Q 103702 UPD: DOC: Data Access Guide Index -- A through Me               15

Q 103703 UPD: DOC: Data Access Guide Index -- Mo through Z               16
Q 103807 How to Convert a Text File into a New Access Database           4
Q 103808 Limitations of the Data Control in Visual Basic Version 3.0     2
Q 104155 Examples Show How to Query BIBLIO.MDB Database                  4
Q 104459 PRB: Error 3219 When Updating Record Set Created w/ Distinct    2

Q 104875 How to Encrypt a Microsoft Access Database in Visual Basic      2
Q 104983 Referential Integrity Enforced for DBs Created in Access        2
Q 105171 PRB: Error 13 (Type Mismatch) & Error 3061 w/ SQL Queries       2
Q 105173 How to Query for Dates Using a SQL Statement in VB 3.0          1
Q 105990 How Visual Basic Handles Security Set by Microsoft Access       7

Q 107751 LONG: PERFORM.TXT - Performance Tuning Tips for VB and Access   7
Q 109830 How to Speed Up Data Access by Using BeginTrans & CommitTrans   2

Q 112195 How to Read Database Fields Into and Out of a List Box          2
Q 112767 How to Perform Microsoft Access Macro Action Via DDE from VB    1

Q 113332 BUG: AddNew Method Gives Error: Illegal Function Call           2
Q 113390 How to Delete All Records from MDB Database Table In VB 3.0     3
Q 113436 How to Drag Data from a Grid to a List Box in VB 3.0            3
Q 113589 How to Highlight an Entire Row of Cells in the Grid Control     1
Q 113592 How to Perform a Union Query in Visual Basic Version 3.0        2

Q 113594 Updated ACC2COMP.TXT for Jet 2.0/VB 3.0 Compatibility Layer     7
Q 113684 Install Issues Microsoft Jet 2.0/VB 3.0 Compatibility Layer     2
Q 113685 Files Included in Jet 2.0/ VB 3.0 Compatibility Layer           2
Q 113687 BUG: Field Name Same as Reserved Word Can Cause GP Fault        2
Q 113899 How to Convert a Database Table into an Excel Spreadsheet       2

Q 113901 How to Query for Literal Special Characters in a Where Clause   3
Q 113903 DOCERR: More Info & Doc Fixes for FindFirst & Seek Methods      3
Q 113951 How to Obtain & Distribute the Compatibility Layer              2
Q 113955 How to Use FindFirst with Strings that Have Apostrophe in VB    4
Q 113956 How to Use TOP N Query from Microsoft Access 2.0 in VB 3.0      2

Q 113957 How to View Photos from the NWIND.MDB Database in VB 3.0        4

Q 114344 How to Perform SubQuery on Microsoft Access 2.0 DB in VB 3.0    3
Q 114771 BUG: Disk or Network Error with Data Access Objects             2
Q 115779 BUG: Compacted 1.1 DB Becomes 2.0 DB w/ Compatibility Layer     2

Q 115833 How to Use the New MS Access 2.0 DDL Additions in VB 3.0        5
Q 115976 How to Modify VISDATA Sample to Work with Compatibility Layer   4
Q 116034 PRB: Compatibility Layer Error: Can't open any more tables      2
Q 118647 PRB: No Tables Listed in RecordSource of Data Control           2
Q 119112 PRB: GPF in MSAJT200.DLL Viewing SQL Prop. of Pass-Thru Query   2

Q 119244 BUG: No Error Produced when Data Changed in DataControl         2
Q 119732 ComLyr Files Needed when Distributing VB Applications           2
Q 119733 BUG: Error with Edit Method After Rollback of Previous Edit     2
Q 119738 How to Quickly Search a List Box                                2
Q 124709 UPD: Out of Memory Error w/ AddNew/Update on Dynaset or Table   3

Q 129882 How to Optimize SQL Queries in Visual Basic 3.0 and 4.0         2

Keywords          : RefsPSS vb3only kbref
Version           : 3.00
Platform          : WINDOWS
Issue type        : kbinfo
Solution Type     : Info_Provided