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...
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...
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...
I've developed a procedure to export our products (CDs/DVDs..) to html files using .writeline(recordset("Artist_Name"). 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...
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)...
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
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 "LIKE '%Enya%'".
Is there any way of specifying that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.