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."
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+
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 RepliesI 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 RepliesI'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 RepliesI 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 RepliesI 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 RepliesI'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
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 RepliesI 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 RepliesMy 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]...
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]....
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 RepliesPreviously 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 RepliesI would like to know if there a way to Compact and Repair an Access 2007 Database Programmatically Using VB 2010?
View 2 RepliesBeing new to vb.net, how do i get a exec mod for the desktop ??
View 8 RepliesThe code below is right to execute more store procedures?
Dim mySQLCommand1 As New SqlCommand("sTruncate", myConn)
Dim mySQLCommand2 As New SqlCommand("sAddress", myConn)
Dim mySQLCommand3 As New SqlCommand("sProvider", myConn)
[code]....
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
I'm having troble getting my code to recognize the parameter for my Stored Procedure.This code below show how I select my files (commented out all other files to make sure one works first)It selects my files through the OpenFileDialog box, it loads the name & location of the csv file into memory and then I want to run a SP to import the csv into my database. I have set the SP up ok as it works through SSMS. [code]
View 8 RepliesI am developing a solution in .Net utilising the VMWare Web Service API to create new isolated virtualised development environments. The front end will be web based. Requestors input details for the specific environment which will be persisted to SQL. So I need to write an engine of some sort to pull the data from SQL and work on the long running task of creating resource pools, switch port groups and cloning existing VM templates etc. As work progresses, events will be raised to write logs and update info back to SQL. This allows requestors to pull data back into a webpage to see how it's progressing or if it's completed.
The thing I am struggling with is how to engineer the engine which will exec the long running task of creating the environment. I cannot write a windows service (which I would like) as we work in a very secure environment and it's not possible (group policy etc). I could write a web service to execute the tasks, extending the httpRuntime executionTimeout to allow the task to complete. But I'm keen to hear what you guys think may be a better solution to use (based on .Net 3.5). The solution needs to be service oriented as we may be using it on other projects within our org. What about WWF, WCF? I have not used any of the newer technologies available since .Net 2.0 as we've only just been approved to move up from .Net 2.0.
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]....
How can i compact my outlook 2007 pst file?
View 4 RepliesI 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 Repliesim 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]....
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].....
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]...
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?
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]....
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 RepliesI 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