From: jprobb@seniortrans.com   
      
   Hello:   
      
   I am using VB 6.0 with a Windows XP Professional environment.  I am also   
   using Access 2000.  I am currently building a program and need reporting   
   capabilities.  So, I started a Data Project (first time I've ever used it so   
   it's already a "mystery").   
      
   I clicked on DataEnvironment1 and showed the object.  Then I added a   
   connection.  Used the wizard and under:   
      Provider  I Selected Microsoft Jet 4.0 OLE DB Provider   
      Connection I selected the database that I want to connect to.  My.mdb   
   (it is Access 2000)   
                           User name:   Admin   
                           Blank password:  checked   
                           Tested Connection: Clicked and got popup tht said   
   "Test Connection Succeeded"   
     Advanced:  Selected "Share Deny None"   
      
   Then hit "OK"   
      
   I used the icon along the top menu to add a child command:  Command 1   
      Did a right click and went to properties   
      
       General Tab:   
           Command Name:  Command1      Connection:  Connection1   
           Selected Database object Option and changed it from "Stored   
   Procedure" to "Table"   
           Object Name:  is blank...so hit the down arror and got a message:   
               Visual basic has encountered a problem and needs to close.  We   
   are sorry for the   
                inconvenience . . .   
      
       And the program closed.   
      
   I've tried a different connection:   
        Provider:  Microsoft OLE DB Provider for ODBC Drivers   
        Connection:  I tried the option Use DAta Source Name and selected "MS   
   Access Database"   
               Admin   
               My.mdb  (Access 2000)   
      
       Test connection:  Test connection failed because of an error in   
   initialilzing provider. 0x80040e21   
      
       Tried it with data source "Microsoft Access 4.0   
       Got the same error   
      
       In other parts of my program I've had to program connections for every   
   database/table from Access 2000...could not use a data control that would   
   work with Access 2000.   
      
        I've tried Crystal Reports, but it is a "bear" to distribute with my   
   program...tried it with other programs and can't get a handle on all the   
   dependencies and all that must be loaded with it onto the other machines..   
      
   So just really having problems ... and I need to be able to run reports on   
   the data.   
      
   Help!! Please... Is Access 2000 able to be used with the DataEnviroment and   
   the DataReport?   
      
   Any assistance would be appreciated.   
      
   JP   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)