Results 1 to 4 of 4

Thread: Access 2000 and VB6

  1. #1

    Thread Starter
    Lively Member Backbraker's Avatar
    Join Date
    Dec 2000
    Location
    Lummen, Belgium
    Posts
    117

    Question

    Hellooo,

    i'm making a prog using Access 2000 and VB6. I'm using ADO and use the Microsoft Jet 4.0 Engine to make the connection.
    The connection is good when I test it. When I write SQL commands in the DataEnvinronment (for example a simple select) and I want to Run it, VB says : "Unknown Error".
    That's all, no description... nothing...
    Does anyone know what this could be?

    No code has been inserted so far, just 1 form, 1 dataenvironment and 1 SQL-command...

    [Edited by Backbraker on 01-17-2001 at 06:09 AM]
    Breaker

    (VB 6.0 ENT SP3 WIN 2000 PROF)=> WORK
    (VB 6.0 ENT SP3 WIN ME)=> HOME -> Upgrade to .NET is coming

  2. #2
    Fanatic Member
    Join Date
    Feb 2000
    Location
    Dunmow,Essex,England
    Posts
    898
    Dont know off hand if it'll solve your problem, but it may be worth going to SP4 for VB since a lot of the controls have had fixes to them. This might just be one of those controls.

  3. #3

    Thread Starter
    Lively Member Backbraker's Avatar
    Join Date
    Dec 2000
    Location
    Lummen, Belgium
    Posts
    117
    No, because i allready wrote programs the same way and they do work fine...

    thx anyway...

    PS : Is it worth installing sp4? Right now I have sp3 installed...
    Breaker

    (VB 6.0 ENT SP3 WIN 2000 PROF)=> WORK
    (VB 6.0 ENT SP3 WIN ME)=> HOME -> Upgrade to .NET is coming

  4. #4
    Fanatic Member Jerry Grant's Avatar
    Join Date
    Jul 2000
    Location
    Dorset, UK
    Posts
    810
    It's always worth installing service packs, as they were issued to fix known problems. If you dont do any of the following then you don't need it!

    Fixes in the Service pack for VB:
    Q168824: Setting the Text property in the Click event of a ComboBox control causes the text field to be blank.
    Q257516: Buttons removed from a ToolBar control no longer appear in the Customize dialog.
    Q257530: Changing the order of buttons in a ToolBar control causes duplicate images.
    Repeatedly loading and unloading a WinSock control at causes a memory leak. This has been fixed when running in the IDE, but not at run-time.
    Q257792: NodeClick events in a TreeView control are triggered even though the CausesValidation and HideSelection properties are True and another control losing focus returns "Cancel = True" from its Validate event.
    Q232194: The OpenURL method of the Internet Transfer Control truncates downloaded files.
    Q224181: Setting the Checkboxes property to True in the ListView and TreeView controls causes excessive resource usage.
    Q245159: Using the SendData method of multiple Winsock controls may block all but the most recently established connection and may cause loss of data.
    Q257630: Calling the End statement in the Unload event of a form containing a Coolbar control caused an "Invalid Page Fault".
    Winsock control stops responding when receiving UDP packets with a 0-byte length.
    Q199722: Setting the ControlSource property of the RichText control in Access results in a "Property cannot be set" message when entering preview mode.
    Q239943: Negotiated menus in UserControls caused excessive resource usage.
    Q257686: Calling the Unload method in the DoubleClick event of a ListBox control caused an "Invalid Page Fault."
    Q257692: The IMEMode property of the TextBox and ComboBox controls caused excessive resource usage in compiled applications on the Japanese version of Windows 98.
    Q257710: The PointSelected event of the Chart control returned an incorrect DataPoint.
    Q242355: In the KeyDown event of a PictureBox control sited on a UserControl, no KeyCode was returned for the HOME, END, PAGE UP, and PAGE DOWN keys.
    Q257661: Double-clicking a modal form shown from as SSTab control caused a MouseDown event to be fired on the SSTab control.
    The current row in a DataGrid control changed each time a DataAdapter was re-bound to an OLE Simple Provider DataSource.
    Q257662: Attempting to enter text into a ListView control with IME set to a double-byte input option can cause an "Invalid Page Fault." This occurs with Japanese Visual Basic on Japanese Windows 98.
    Q182068: A ListView control can't read the SubItemIndex property of a ListView control in a Visual Basic 4 executable file.
    Q257780: The Data control reported an "unrecognized DB format" error when attempting to bind to an Access 2000 database.
    Changing the Name of a control in the Properties window could cause an "Invalid Page Fault" in Visual Basic under certain circumstances.
    Q246233: Selecting the DataSource property of a TextBox control on a nested UserControl could cause an "Invalid Page Fault."
    Q240946: The ListView control failed to recognize mouse events when the MultiSelect property was set to True.
    Q257784: Cells in a DataGrid control containing double-byte characters could not be accessed using ARROW keys on Japanese systems.
    The size of a DateTimePicker control changes between design time and run time when placed on an Outlook form.
    Q257788: Navigating through a DataGrid control by clicking on rows doesn't submit updates.
    Q257741: The Validate event of an intrinsic control sited on a UserControl causes an Access Violation in Italian Visual Basic.
    Q257495: ListView controls generate the ItemClick event twice when the LabelEdit property is set to Manual.
    Creating and populating a control array of ListView controls could cause an "Invalid Page Fault."
    Q257635: The wrong row had focus in a DataGrid control after repeatedly canceling the addition of new records.
    Q248416: Clicking on a node of a TreeView control with the SingleSel property set to True caused the wrong node to expand.
    Setting the DataSource property of an ADOData control programmatically cause excessive resource usage.
    The RichText control failed to instantiate on a Web page when Internet Explorer is installed after Visual Basic 6 is installed.
    Repeatedly loading and unloading a form containing a Hierarchical FlexGrid control caused excessive resource usage.
    Using a comma as a decimal separator caused an incorrect value in the DataGrid control in Danish Visual Basic.
    Setting the PalletteMode property to UseZOrder on a form containing a Hierarchical FlexGrid control caused an "Invalid Page Fault."
    Setting properties of a TextBox control in the Initialize event of a UserControl caused data binding to fail.
    Q212733: The contents of a RichText control couldn't be viewed in a report.
    Q257772: A TextBox bound to a RDC control failed to update when the CursorDriver property was set to UseClientBatch.
    Q257726: Updates to a DataGrid control could fail when using a Jet 4.0 OLEDB provider.
    Q257400: Calling unload from a CheckBox control could cause a General Protection Fault in Visual Basic on Windows 98.
    Q257523: Displaying a Windows Metafile (.wmf) in a PictureBox could cause excessive resource usage.
    Q251225: The EditMode property of an ADO Recordset was not set properly when bound to a DataCombo control.
    Q257694: Changing the RowSource property on a DataCombo or DataSource control caused an incorrect reference in the BoundColumn property.
    Q237895: Unloading a DBGrid control from a control array caused a General Protection Fault on NT 4.
    Q260285: The FieldChangeComplete event failed to fire for a TextBox contained in a UserControl.
    The Q numbers are the relevant MSDN topic numbers.


    Jerry Grant................tnarG yrreJ
    Website: <JG-Design></.net>
    Email: [email protected]
    Working towards a bug free world......
    (Not a Microsoft employee)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width