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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by PhilMatAmber

  1. PhilMatAmber

    Left Join with a Where clause

    I think your where condition is filtering the recordset down to only those rows that match cm.eid=46... thus screwing up your left join approach. A subquery might come to your rescue, pardon any syntax errors but try this: Select c.*, cm.* from committees c left join (SELECT * FROM...
  2. PhilMatAmber

    Access Version Question

    If you're using ADO (ideally) to reference the Access DB then using OLEDB.4.0 provider can connect to either Acc97 or 2000 (small performance penalty if you use 97). If you're using DAO then (I believe) it does not matter which version you attach to (your VB project can reference the later...
  3. PhilMatAmber

    Client/Server Reliability

    It's not exactly what you were looking for, but why not use a client-side, batch update, disconnected ADO cursor to make your updates. Use a timer to keep reconnecting to update. If you can't reconnect, the server is down, oh well, try again next timer interval. Has the advantage of keeping no...
  4. PhilMatAmber

    CRViewer: Physical database not found. on NT install

    This message: Physical database not found does not necessarily mean what it says, like most of the crummy Crystal messages. However, if you look it up on the Crystal site you'll get hits... I remember I had to do something, can't recall what, to the report definition because it thought there...
See more

Part and Inventory Search

Back
Top