Compacting an Access database from ASP code
This 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.
<%
oldFile = Server.MapPath("db.mdb")
newFile = Server.MapPath("bak.mdb")
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& oldFile
strConnBak = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & newFile
Set objJRO = Server.CreateObject("JRO.JetEngine")
objJRO.CompactDatabase strConn, strConnBak
Set objJRO = Nothing
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
If objFSO.FileExists(newFile) And objFSO.FileExists(oldFile) Then
objFSO.DeleteFile(oldFile)
objFSO.MoveFile newFile, oldFile
Response.Write "Compact and Repair was successful."
Else
Response.Write "Compact and Repair failed."
End If
Set objFSO = Nothing
%>
Comments:Only members can write comments.Please,
login /
register to write comment.
Best HTML5 Books
Here is the list of top HTML5:Â HTML5 For Web Designers , Â Introducing HTML5, Pro HTML5 Programming, Dive Into HTML5. Examples, frameworks, source codes and sample chapters can found at from original websites and directly download as e-book or order online
Getting the primary key value of the record
Often, we need to insert a new record in a table with an autonumber
variable as primary key, and get the value of the automatically
generated primary key back. For instance, when we start a new session
for a user, and we need the sessionID to insert as a foreign key into an
order table or so.
Simple PHP SOAP example
This post will show a simple example of how to interpretate a WSDL file and a very simple, yet quick example of how to extract information from this file through PHP.
In this example I assume that you've already have SOAP enabled in your PHP configuration because this is beyond the scope of this example. If you're not sure, you can check your phpinfo file.
Using an alternate JSON Serializer in ASP.NET Web API
The new ASP.NET Web API that Microsoft released alongside MVC 4.0 Beta
last week is a great framework for building REST and AJAX APIs. I've
been working with it for quite a while now and I really like the way it
works and the complete set of features it provides 'in the box'. It's
about time that Microsoft gets a decent API for building generic HTTP
endpoints into the framework.
How to Convert a PSD to XHTML
I continue to be amazed by how well Collis’s “Build a Sleek Portfolio
Site From Scratch” tutorial continues to perform. It’s been months, yet
it still posts strong numbers every week. Considering that fact, I
decided to create a screencast that shows you exactly how to convert a
PSD into perfect XHTML/CSS. (Read More)
Source Code
