home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 10,069 of 10,840   
   Harvest Wind to All   
   SQL in VB 6.0 Not returning data from Pa   
   26 May 06 23:35:50   
   
   From: HarvestWind@comcast.net   
      
   Hi:   
      
   I have a program in VB 6.0 that connects to an access database and connects   
   to a paradox database (directory)... I query an Access table and it returns   
   the data I need...as the program begins.  The operator selects a date and   
   then presses a command button which starts a query on a Paradox table in   
   it's directory (database to which I made the initial connection)...and it   
   returns data on my machine...and on four other machines in our offices...   
   however, there are two machines (same exact program) where the Access Data   
   is returned...but the SQL for the Paradox table returns no data...  I have   
   had the operator of one of the "non functioning" machines sign out and sign   
   in my machine...run the program...and it works ...  so it's not a   
   premissions problem.  I can't figure this one out.  Does anyone know why   
   this might be happening?   
      
   My machine (the development machine) is running Windows 2000 XL   
   professional...the others are running 2000...with the latest service   
   packs... the program works on some but not all of the "2000" machines ...   
      
   Anyone have any ideas?   
      
   Thanks   
   HW   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca