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: *

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

    Disconnecting dBase indexes?

    I currently link to dBase (the dos version) tables using MS-Access, however, I need to disconnect the dBase indexes before doing this (using dBStructure as I don’t have a licensed copy of dBase). Is there a way to remove the index and disconnect them using either VBA or Access (or any other...
  2. Phydos

    Disconnecting dBase indexes?

    I currently link to dBase tables using MS-Access, however, I need to disconnect the dBase indexes before doing this (using dBStructure as I don’t have a licensed copy of dBase). Is there a way to remove the index and disconnect them using either VBA or Access (or any other method)? Thank you...
  3. Phydos

    Disconnecting dBase indexes?

    I currently link to dBase tables using MS-Access, however, I need to disconnect the dBase indexes before doing this (using dBStructure as I don’t have a licensed copy of dBase). Is there a way to remove the index and disconnect them using either VBA or Access (or any other method)? Thank you...
  4. Phydos

    I've developed a procedure to expor

    I've developed a procedure to export our products (CDs/DVDs..) to html files using .writeline(recordset(&quot;Artist_Name&quot;). However, I would like to optimise the html files by removing the 'new lines' i.e. change: BLINKIT<br> BLISZ<br> BLIT<br> BLONDES<br> BLONDIE<br> to...
  5. Phydos

    IMPTechnology, Full-Text alternative?

    We don’t have Full Text Indexing on our server, so have chosen to use IMPTechnology for the search on our Music store www.phydos.com. It does allow for very fast searching, but the strain on the server is high while indexing (it’s overloaded a couple of times – and tends to take a few hours)...
  6. Phydos

    Stored Procedure to run standard SQL queries?

    I have a number of SQL Update, Insert and Delete queries setup which I run as a batch in Query Analyser, is there a simple way that I could create a single Stored Procedure to run these, rather than create specific Delete...etc Stored Procedures? Regards, Phydos
  7. Phydos

    Search website - returning 'Kenya' when looking for 'Enya'

    I have an ASP - SQL query (for a music/media webpage) which searches for keyword, the problem the site has is that it returns words within words, for example; search for Enya, and it returns Kenya (and lots of them). The search uses &quot;LIKE '%Enya%'&quot;. Is there any way of specifying that...

Part and Inventory Search

Back
Top