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!

  • Congratulations TouchToneTommy 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: *

  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

    tried a couple other options. set up a linked server in enterprise manager using microsoft.jet.oledb.4.0 as the provider and 'dbase III' as the provider string. using query analyzer this statement works: select * from openquery(dbflink,'select * from dbtable') however, if i open the dbf file...
  4. mterveen

    nested joins

    thx john76 for the reply. that is what i ended up doing also and it worked. haven't double checked the results yet as to accuracy but it appears ok. concern i originally had was if there needed to be any parens used to correctly group the data.
  5. 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...
  6. 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) | |...
  7. mterveen

    DAO Recordset Insert

    thot i should update the post. after a LOT of trial and error i got the insert into ... openrowset syntax to work and its very fast. hardest part was the proper setup of the dbase provider syntax. however, as always, once it works the answer looks so simple!!
  8. mterveen

    DAO Recordset Insert

    Unfortunately it is a recordset i have (versus tables) so that is the reason for my question. i need to join the dbase tables/files and have found that the only reliable method is to use the dao provider. so i'm stuck at this point with a dao recordset. the recordset methods include a...
  9. 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"...
  10. mterveen

    win 98/xp slow

    thx again for the input. we actually reinstalled win95 on the pcs that need the app since the alternative was unacceptable. will let you know what i come up with.
  11. mterveen

    multi user query issue

    After some research decided using sql temp tables would meet my needs. thanks for the suggestion tho.
  12. mterveen

    win 98/xp slow

    thx. will pass the info on to our clipper programmer.
  13. 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...
  14. 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...
  15. mterveen

    laserjet 1200 pcl command

    That worked like a charm. Thx for the help.
  16. 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...
  17. mterveen

    Function "Date()" is not available??

    thx for the posts. it was so simple once i looked closely. there was indeed a reference to a file that was missing. i just copied the file from the programming computer to the users computer and it worked.
  18. mterveen

    Function "Date()" is not available??

    did you ever get this issue figured out? i just moved an access application to another computer and all the aggregate queries that use trim(), date() etc get this error. using access 97 on win 95 and moved it to a win98 machine. i am perplexed to say the least.

Part and Inventory Search

Back
Top