Compact A Access 97 MDB File In .NET?

Jan 27, 2011

I am trying to compact a Access 97 MDB file. I have found and tried the following code

Private Sub CompactDB()
Dim jro As JRO.JetEngine
jro = New JRO.JetEngine()
jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<DATAPATH>", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<DATAPATH>;")
MsgBox("Finished Compacting Database!")
End Sub

This codes works and seems to compact the file and it appears in the destination folder but when i try to open the new file i get an error "Unrecognized database format 'DATAPATH'"Is there something i am doing incorrect? the database file sizes range from 5Mb to 100Mb+

View 13 Replies


ADVERTISEMENT

Can't Compact My Access Mdb File Using Exec Outside IDE

Sep 25, 2009

I have a compacting subroutine which basically call for MSAccess compacting[code]...

It runs without a problem in VB 2005 IDE, no problem at all. However, when I compiled it, and build the set up, and deploy it. It throws up this exception:

"Could not load file or assembly 'Interop.JRO, Version=2.6.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."

View 3 Replies

.net - Export Data Of Sql Compact Database (mdf File) To Access Or Excel Or CSV Format?

Jun 27, 2012

i Have Used Database file for storing Data in my Application.Now I want to take backup of data in Access, Excel or in Any other Format.

View 1 Replies

Compact A Access Database Without Using DAO And JRO?

Mar 26, 2009

I am using Access database. Now i compact the database by using DAO and sometimes using JRO. But to this both, we have add the COM reference.

View 2 Replies

Compact An Access Database In Program2010?

Apr 7, 2011

I'm updating an old VS 2003 project to VS 2010. Part of the application uses the old JRO COM object to compact the database. That seems to be depreciated in 2010.

View 1 Replies

Compact And Repair Access Databases?

Oct 22, 2010

I am looking for some sample code to use in VB2008, in order to compact and repair Microsoft Access MDB files and ACCDB files.

View 1 Replies

Locked Access Db - Can't Compact Or Delete Ldb

Aug 23, 2007

I have VB 2005 windows application that is reading and writing records into Access 2003 database. After I deployed application to multiple servers - the database stays locked all the time - even if nobody has it open. When I check open files through Computer Manage - it doesn't show that anybody has it open. Yet - I can't delete .ldb file, I can't repair and compact the database to replace existing database, I can't rename database to replace it with other version.

View 6 Replies

Closing An Access Database Before Running A Compact?

Nov 29, 2011

I'm using the Microsoft Access Database Engine and trying to do a compact using the following code:

Dim acc As New Dao.DBEngine
Try
acc.CompactDatabase(serverDataPath & "MQRMeta.accdb", serverDataPath & "MQRMeta.001.accdb")
Catch ex As Exception
PrintLog(modName, rtnname, "Error compacting database. " & ex.Message, "MQR2500E:")
End Try

View 2 Replies

Compact / Repair Access 2007 Database?

Mar 16, 2009

Has anyone succeed to compact an Access 2007 database via VB.net code? The previous methods from JRO don't work anymore and there is no help on msdn on how this could be done for 2007. compacting this database?

View 3 Replies

Compact And Repair Access 2003 Database

Feb 1, 2007

I am using VB .NET 2005 and I would like to compact an Access 2003 database.I've read "How to compact a Microsoft Access database by using Visual Basic .NET" from the knowledge base but it will only save in Access 2000 (link below).Attempting this with a 2003 database throws an exception about not being able to save it as an older version (losing features and what not).Is there a way to do this with a 2003 database? url....

View 3 Replies

Database - Losing Access DB Password On Compact?

Aug 17, 2011

My VB.NET program compacts and repairs my DB, but somewhere in the process unsets the database password. No problem, just reset it through VB, right? not sure how to go about that task.

So I either need to know how to compact it without losing the password, or how to reset the password after I lose it. Trying the best I can to make the code look decent in my post, let me know if there is a better way.

Dim strAccessDatabasePath As String = System.AppDomain.CurrentDomain.BaseDirectory & "App_DataSquirrel.accdb"
Dim LockedDbFileInfo As New System.IO.FileInfo(strAccessDatabasePath.Replace(".accdb", ".laccdb"))
Dim TempFolder As String = System.AppDomain.CurrentDomain.BaseDirectory & "App_Data emp"
Dim TempDB As String = TempFolder & " emp.accdb"

[Code]...

View 1 Replies

Losing An Access DB Password On Compact : How To Reset From VB

Jun 9, 2011

My VB.NET program compacts and repairs my DB, but somewhere in the process unsets the database password. No problem, just reset it through VB, right? Ummm... not sure how to go about that task. So I either need to know how to compact it without losing the password, or how to reset the password after I lose it.

Dim strAccessDatabasePath As String = System.AppDomain.CurrentDomain.BaseDirectory & "App_DataSquirrel.accdb"
Dim LockedDbFileInfo As New System.IO.FileInfo(strAccessDatabasePath.Replace(".accdb", ".laccdb"))
Dim TempFolder As String = System.AppDomain.CurrentDomain.BaseDirectory & "App_Data emp"
Dim TempDB As String = TempFolder & " emp.accdb"

[code]....

View 1 Replies

Using Stored Procedures With ADO.Net And MS Access Or SQL Server Compact Edition

Jan 11, 2011

I have an application that is currently using DAO and would like to move it to ADO.Net. The problem I'm having is that when I do, I cannot do any queries that take variables if the database is Access or SQL Server Compact Edition. For example: SELECT RecipeName FROM tblMasterRecipe WHERE CategoryID = iCategoryID..The database is a local standalone database. Of course if I use the Standard SQL Server I can add parameters just fine using the TableAdapter Query Configuration Wizard. How do I do something similar for Access or SQL Server Compact Edition? The Create new stored procedure radio button is greayed out when the database is Access or SQL Server Compact Edition.

View 6 Replies

Compact Access Database - Error: Cannot Create ActiveX Component

Oct 26, 2009

Previously this was not problem on XP/Vista (with minor changes), but windows 7 (64bit), is having issue's and I thought it might be how I'm implementing this time around? This is the original version just gives a com exception error of {"Cannot create ActiveX component."} [Code]

View 1 Replies

Compact And Repair An Access 2007 Database Programmatically Using 2010?

Aug 30, 2011

I would like to know if there a way to Compact and Repair an Access 2007 Database Programmatically Using VB 2010?

View 2 Replies

Setup File - Developed A Software Using SQL Compact Edition Database (.sdf File)

Nov 15, 2011

I've developed a software using VB.Net and SQL compact edition database. (.sdf file) Now i want to add my .sdf file to setup file. I've search internet and create setup file. when i install the software, it is created new folders in program files including my database file and exe file. after double clicking exe file, it is open the software. but when using, it's shown a message "connection current state is closed". but when i run my vb project, it is working well.

Other details.

1) I create data base inside of /bin/debug

2) I've created setup file using this method. File menu --> add --> new project Then, Setup and deployment -> Visual studio installer After that I selected Setup project, then click OK.

3) I add database using this Right click on setup file -> add -> file (In solution explorer window) Then i selected my .sdf file.

This is my connection string

CODE:

It is created only 3 files in Program files.
1. my exe
2. my sdf file
3. System.Data.SqlServerCe.dll file

View 5 Replies

Compact Framework Download File From Url

Jan 25, 2012

I need to replace WebRequestFactory, what is this doing?

Public Shared Sub download_file()
Dim wr As HttpWebRequest = CType(WebRequestFactory.Create("http://www.test.com/test.jpg"), HttpWebRequest)

[Code]....

View 1 Replies

Compact Outlook 2007 Pst File?

Feb 7, 2011

How can i compact my outlook 2007 pst file?

View 4 Replies

VB SQL Express 2010 - Compact .sdf File

Jul 22, 2010

I created a SQL Compact Edition .sdf file in VB 2010 Express. I set the first column in the table as a Primary Key. But can I make use of it or am I limited to scrolling all the way through the file until I find the match I want? I managed to use a primary key with a SQL server .mdf file using the FindBy statement, though as a beginner, didn't really understand what I was doing so resorted to the more simple sdf file format to get me started. Goodness me there's so much to learn about data handling, it took me days to find out I didn't need a .Net provider in the connection string for Compact Edition.

View 3 Replies

Read Text File In .net Compact Framework?

Jun 10, 2011

im trying to creat a pocket pc application using visual basic. but i got problem access text file. system always shows that "counld not find a part of path". the code i wrote is like:

Imports System
Imports System.IO
Public Class Form1

[code]....

View 7 Replies

Connecting To SQL Server Compact Edition Database File?

Dec 2, 2010

I have made a SQL Server Compact Edition Database File (.sdf) and created tables inside. However as I am new to SQL Server I don't know how to connect to the database using VB .NET.Code I have now:

Dim sqlcn As New sqlconnection()
Dim sqldataset As New DataSet()
Dim sqlda As SqlDataAdapter[code].....

View 16 Replies

Combining Image Files - Take Multiple Picture Files And Compact Them Into One File

Dec 10, 2009

I know this is out there and probably illogical but I was wondering if it was possible to take multiple picture files and compact them into one file.... and then retrieve them from the program later? Way to combine any amount of image files into one file

Module Module1
Sub combine()
Dim img1 As New Bitmap("i1.jpg")

[CODE]...

View 6 Replies

.net - Access A Accdb File (MS Access 2007) From Resources?

May 27, 2011

I am writing a very simple program that connects to a accdb file (Microsoft Access 2007 file) and returns some results in a datagridview. Everything is fine. Now because we have to deploy this program in many computers i publish it so everyone we want can install it and have updates. What i wanted to do is to make the database file part of the program which i did it by adding it to the resources. My problem is that i do not know what connection string to enter in order to access it in my resources.
My previous connectionstring before i deploy it was this

ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:l.accdb;Persist Security Info=True

What should i change in the data source in order to access the same file in my resources?

View 1 Replies

Add Record To SQL Compact DB?

Dec 18, 2010

however i have always had issues with databases... so i abandoned it and went into web design instead. Php and sql are so easy there is nothing i cant do with them.I created an Sql compact database which i can connect to and navigate using the following code... but that is it. i cant seem to add to db in any way shape or form.

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.AddressTableAdapter1.Fill(Me.TestsqlcDataSet1.address)
End Sub

[code]....

View 2 Replies

Using SQL Compact Edition?

Dec 3, 2011

Im looking for some advice on the deployment of an application using SQL Compact Edition.My application will only be used by two people on two separate desktops with file sharing enabled.My goal is to deploy the application and have the .sdf file located on one of the desktops in a shared folder. So the other person using the app can connect to that database too.What is the best way to setup the deployment of this so that I can place the DB in lets say c:DBMyDB.sdf

View 5 Replies

File I/O And Registry :: Random Access File Larger Than Text File?

Jan 7, 2009

I am writing a program to calculate Pi to several hundred billion decimal places and this will require lots of GB of memory. I wrote a test program in VB2008 that saved the first 16 digits of Pi (without the decimal point) to both a text file and a random access file, just to be sure it was outputting the numbers properly. For reference the first 16 digits of Pi are:

View 8 Replies

Add Data To SQL Compact Database?

Dec 7, 2010

How can I add data to SQL Compact Database from DataGridView?Striving to do my best.

View 2 Replies

Add SQL Compact Database To Project?

Aug 4, 2009

I am new to vb 2008 and I can't seem to figure this out.

When I try to add a database to my project I get this error (Please look at .jpg (Firsterror)

I have selected the correct driver SQL Compact 3.5

It will add the database to the project but the FULL PATH is always incorrect and I can't change it. (Please look at my seconderror.jpg) the correct path is C:SQLSample.sdf

View 13 Replies

Default Format For Sql Compact?

Apr 2, 2012

I am trying to set a default datetime for sql compact but I receive an overflow.

Does anyone know the default format for sql compact? I thought it was yyyymmdd

View 3 Replies

How To Add Sound To .net Compact Framework 2.0

Nov 16, 2008

I need to create a sound if validation fails. Anyone know how to do that? It can be a wave file or any kind of format.

How can i create a sound in .net compact framework 2.0. using vb.net. I saw codes asking to use system.media class. However in compact framework there do not seem to have this class.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved