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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
What is the VB code to compact a database?
I know this post is a little late but if you haven't found what you need try this. If you are processing the updates at night via a scheduler, the easiest way to compact is to use the /compact command line switch. i.e \path to access\msaccess.exe \path to database\mydb.mdb /compact. This will...- lewi
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
ASP and database slashes
Is there a function like in php AddSlashes which prepares data to be inserted in a query ? (I don't want to use the cmd object for other reasons) so if the data contains " ' it will be formatted like: \" and \' thnx in advance, grtz lewi- lewi
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
