Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mterveen
  • Content: Threads
  • Order by date
  1. mterveen

    ole cursor location error

    Don't quite know which forum to put this in so sorry if wrong one. Having trouble with linked server under sql server 7.0 that links to .dbf files using ms jet ole 4.0 provider. when i query a large table it returns around 1000 records then bombs out with error "search key not found in any...
  2. mterveen

    ole cursor location error

    Don't quite know which forum to put this in so sorry if wrong one. Having trouble with linked server under sql server 7.0 that links to .dbf files using ms jet ole 4.0 provider. when i query a large table it returns around 1000 records then bombs out with error "search key not found in any...
  3. mterveen

    dbase openrowset exclusive

    using the following text to open copies of .dbf files located on the server: select distinct * from openrowset('Microsoft.Jet.OLEDB.4.0','DBASE III;database=" & serverdb3directory & "','select fld1, fld2 from db3table') " however, now when i want to use the "live" versions of the .dbf files on...
  4. mterveen

    nested joins

    need syntax help on the following join example (all left joins with the field names shown as links). the problem i run into is the link from tbl2 to tbl5 and the proper placement of the parens: tbl1 (fld1) | +--->tbl2 (fld1,fld2) | +--->tbl3 (fld2,fld3) | |...
  5. mterveen

    DAO Recordset Insert

    Have a VB6 app that transfers info from dbase to SQLSERVER 7 tables. the app use a dao recordset to join several dbase files and select/group/sum the records. the recordset is then inserted to an sql table using the addnew method. two questions: 1) is there a way to use the "insert into"...
  6. mterveen

    multi user query issue

    Moving single user access db to multi user sql7 db. Currently have a salesman, customer, and orders table. The salesman table has a boolean (yes/no) field. the user is presented with a bound grid where they can select which salesman to include in an orders report by "checking" the boolean...
  7. mterveen

    win 98/xp slow

    Need some ideas. Clipper app was moved to fresh win 98 and xp installs from win 95. a routine to search and retrieve data from the win nt 4 server on the old win 95 pcs took around 5 seconds. on the SAME pc with win 98 the routine now takes almost 30 seconds! (and about 15 seconds on a hot...
  8. mterveen

    laserjet 1200 pcl command

    i want to send a simple condensed print command thru a dos batch file to my hp laserjet 1200 printer. In the past I have always used Esc&k2S to set my hp Laserjet 6P to condensed. Also i used the same pcl command on an earlier hp 1200. Just hooked up a new hp 1200 and now it won't go...

Part and Inventory Search

Back
Top