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
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 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 RepliesHas 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]...
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 RepliesI would like to know if there a way to Compact and Repair an Access 2007 Database Programmatically Using VB 2010?
View 2 Repliesi 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 have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 RepliesI'm writing a Windows form application in VS 2008. In the application I need to move among several SQL express databases (.mdf). I'm using the following commands to change the connection:
Me.MyTableAdapter.Connection.Close()
Me. MyTableAdapter.Connection.ConnectionString = "NewString"
Me. MyTableAdapter.Connection.Open()
I can see the form is showing data from the 2nd database. However, When I tried copying the 1st database (for a Save as function I'd like to implement), I got a system error saying "Cannot copy MdfFile: It is being used by another person or program.". Actually, I found all the visited databases were "being used" untill I closed my application. How do I break the connection completely?
i am relatively new to VB and i am working on a Visual Basic Program to build a Student Record Book where all the information is stored to an Access 2007 database. If the user is an administrator they will be able to add a new student, update delete etc. I managed to implement INSERT/DELETE/UPDATE functions and also a search button and they all appear to be working fine.
View 4 RepliesI've been researching for days and I've gotten to the point where my WCF service creates an Access object via com/interop.I've ran the Open Current Database call for the Access object without an error but Application.CurrentDB is still nothing/null. If the CurrentDB is nothing then I surely can't call Application.Run "myFunction" I realize WCF services aren't meant to be user interactive, but it's a long story why I'm trying to go this route. Basically I need to have a proof of concept ready sooner rather than later and the alternative (correct) route involves the complete re-writing of a large complex access VBA application. It's not a permissions issue, I have the IIS user names added to the security tab. What I really need is a way to set Environment.UserInteractive to true so my WCF service can create an instance of Access on my server machine, run the VBA functions, close out, return true.I'm using VS 2010 for the WCF, IIS 7 for my server, Access 2010 for the VBA application.
View 1 RepliesI used this code for getting data from delimited text file into access database in VB6 and it is running Perfectly Same thing i want in VB.NET using OLEDB. So can anyone suggest me what code should i use..?
Other info:
Database = mydatabase.mdb
Table Name = SUBSCRIBER
4 Columns = NAME,AGE,GENDER,ID
Text File = temp.txt
[Code]...
I am asked to write a front end program in VB 2005 (that will run in client computers which running on Win XP) to access an existing MySQL database running in Linux. It is not my preferred choice, but the user have the database and server working just as he wants it, and do not wish to change, at the same time I do not wish to change programming language. Is that even possible? Can we actually write VB 2005 programs that will run in client computers complete with NET framework 2.0 to access a Linux operating database?
View 4 RepliesIve created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
I have form1 and form2. A button on Form1 calls a thread background process (below). That process processes the command and when its done should close form2. I'm opening form2 within the current thread but trying to close it in the background thread. This is because if i close it in the current thread it closes immediately. I included the 2 functions below and what I have tried in the inline comments. Form2 is a simple form, basically just an animated gif. It is to show the user that something is happening(like a status bar) then close when its complete. I tried running different priorities instead of different threads but due to the results threading seems to behave the best. I'd like to keep access to both forms during the process, the pc, and screen refreshes realtime.[code]
View 2 RepliesI 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'm lending a copy of my .exe on a memory stick and because I dont completely trust them, , I would like to build in a function that as soon as my app has finished doing what its doing And the big red X is hit it will delete itself, but my problem is that i cant put the deletetion in the form closing because the prog is still running, so what should I do? Is there a way that I can get the app to close as soon as the dedicated task is complete, It will remove itself from the memory stick but if the X is hit before the process is complete the then the prog will remain.
View 14 RepliesHow is it made, controls created in a running application appear again when I reopen it? The images loaded into picturex must be saved in a database?
View 7 RepliesI 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 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 RepliesStop program closing if a special form is running?
View 8 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? 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'm developing Applications in VB.NET 2008.
I have MDI Parent Form and i'm going load all form as MDI child. Here i'm going to give option to "Close All" toolstripbutton in top of MDI Parent to close All mdi child forms.
Now i would like to check that On click of Close All Toolstripbutton , i have to close all mdi child form but except those form is on process, example, I have opened/Loaded 5 MDI child forms within MDI Parent Form.
Child forms are ( just for example ) ,
1. Customer details Form
2. Item Details Form
3. Import Orders Form
4. Stock Details Form
5. Production Entry Form
Here 3.Import Orders form is importing from Excel with 5000 records and 4. Stock details form exporting to excel.
So now if i click "Close All" button then i have close only Idle form i.e 1,2 and 5 but i should not close 3 and 4 since its on some process.
So Is there any .NET option to check that form in process/idle or do I have to check manually by having any Flags ?
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 RepliesI have created a shared add-in in Visual Studio 2008 and using the shared add-in wizard and am coding in VB. When run the add in in Access 2003 I want to check if the user has a database open, so I set a AccessApplication variable to be the application object in the OnConnection procedure and then on a button click I check if AccessApplication.CurrentDB Is Nothing If there is no database open Access will close correctly after the button is clicked. But if a database is open then I have to stop Access in the VS debugger.
[Code]...
How can I add data to SQL Compact Database from DataGridView?Striving to do my best.
View 2 RepliesI 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