NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Compacting an Access database from ASP code
2525
Compacting an Access database from ASP code
http://www.dotnetindex.com/read.asp?articleID=59
source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space.
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Compacting an Access database from ASP code: |
|||
Other links at ASP > Tips and Tutorials > Database-related
some records to a database. This source code helps us to adding records to database without slowing down database.
Category:
Shuffling a recordset so that it can be displayed in random order is very useful when programming dynamic Web pages. A database table containing a list of supported vendors or links to advertisers may need to be displayed in a different order each time so that none complain about always being last on the list.
Category:
This article shows how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. You may already have experience using ADOX or SQL-DMO to accomplish this, but please keep in mind that the method displayed here is meant to be simple enough that anyone with ADO experience can use it. (ADOX and SQL-DMO will be addressed later.)
Category:
Learn how to select a record from database. First we need to calculate how many records we have in our table. Using randomize function, we generate a random number between 0 to count of records in database.
Category:
Building an SQL string from optionally posted criteria is tricky. You need to check if the user posted a value since only then is the criteria included in the query. Numeric entries are different from character entries and multiple-selection fields require additional processing to produce a valid SQL query. Fields that might contain single quotes need special attention to prevent syntax errors.
Category:
Main Category
192
2037
816
286
175
1802
1222
911
1163
7478
70
907
59
2222
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19493
Categories: 1275
Registered Users: 748
Mailing List Subscribers: 2046
Unique Outgoing Hits: 227528
Pagerank Statistics
PHP News