- About us
- Services
- Skills
- Web Development
- ColdFusion Development
- SharePoint Development
- Classic ASP Development
- ASP.NET Development
- Modern ASP .Net Development
- DotNetNuke Development
- Java/JSP/servlets Development
- Python Development
- PHP Development
- Perl Development
- Ruby on Rails (RoR) Development
- Lasso Development
- Real Basic Development
- Google API Integration Services
- Mobile Development
- Database & Client server Development
- Plug-in Development
- Reports/BI Development
- Automated Testing
- QA/Testing Skills
- Domain-based Testing
- E-Commerce Development
- CMS Development
- Desktop Development
- RIA Development
- App-based development
- Salesforce Development
- SugarCRM Development
- Dynamics GP GreatPlains development
- Dynamics SL Solomon development
- Microsoft Dynamics CRM Consulting Development
- Dynamics RMS development
- LiveCycle development
- QuickBooks development
- Drupal development
- Joomla development
- Typo3 development
- Magento development
- Dolphin social development
- Others
- Web Development
- Industries
- Knowledge
- Process
- Models
- Clients
- Career
| |
Software Technology Tips
The Access DB tools provide a way to compact and repair access database.We can achieve the same thing through code in VB.NET using the following steps.
1. Add a reference to "Microsoft Jet and Replication Objects 2.6 Library"
2. Check if the database is in use , display a warning.
[VB.NET CODE STARTS]
Dim strAccessDatabasePath As String ="YOUR ACCESS DB PATH"
Dim LockedDbFileInfo As New System.IO.FileInfo(strAccessDatabasePath.Replace(".mdb", ".ldb")) If LockedDbFileInfo.Exists Then ' Warn user that the db is in use. End If [VB.NET CODE ENDS]
|
3. Create a temporary folder and copy the DB
[VB.NET CODE STARTS]
Rename(strAccessDatabasePath, TempFolder.FullName & "\" & "tmp1.mdb")
[VB.NET CODE ENDS]
4. Create an object of JRO JetEngine and call the compact method , to compact the tempdb and replace at the original location. After compacting delete the temp folder along with its contents.
[VB.NET CODE STARTS]
Dim JRO As New JRO.JetEngine
JRO.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source= " & TempFolder.FullName & "\" & "tmp1.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strAccessDatabasePath & ";Jet OLEDB:Engine Type=5") TempFolder.Delete(True)
[VB.NET CODE ENDS] |
Related Tags:
VB.NET, Compact and Repair Access Database
Author: Amrita Dash
VB.NET
- Compact and repair access database using VB.NET
- Multi-threading and cross-thread function invoke
- Merge Word Documents As Pages Of A Single Document Using VB.NET
- Sorting a user defined collection class
- Open Outlook folder dialog and select folder using VB.NET
- Optimizing code for DataBound Controls in .Net | Mindfire Solutions
- Reading CSV file and extracting records to DataTable in VB.Net
- Creating an Excel sheet from a CSV file in VB.Net
- Execute files with [Run as Administrator] option from code
- HTML to PDF conversion using iTextsharp
- GET POSTAL CODE BY USING GOOGLE GEOCODE MAPS API IN VB.NET
- How to check if MS Word is installed in the machine or not in VB.Net
- VB.Net code to uninstall any application
- Simulate keyboard press events programmatically in VB.Net
- Opening a word document in multiple versions of Word(.NET Windows Application)
- Adding a folder browser control to Set up project
- Adding an e-mail to Microsoft Outlook outbox using VB.Net
- .Net - Produce Special effects when loading or closing windows
- Check if SQL express is installed on target machine
- Open MS WORD or MS EXCEL document and set focus in Vista
- More Related Tips
