here is my code, i am still missing something to copy from SourceDatabase to DestintionDatabase with the suffix "copied"
Dim myDB = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|SourceDatabase.mdb;Persist Security Info=True")
Dim myDB2 = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
[Code].....
copying some record from a table in the same table,changing only the fields of the data(month);- copy last month record fields, and the new records have to date, last month+1(actualy month);- i wish to be a button, like update or copy, to do this;- new filds are added every month;- how i do that?
View 16 Repliesi am trying to create an vb.net program to transfer or copy tables from my access database to an MSSQL DB.I got it working to copy from MSSQL to access but not the other way around.
View 7 RepliesI have two MS Access databases (with identical table structures), and I'd like to use a SQL statement (programmatically in VB.NET) to copy records from one to the other. Both databases are locally stored, in the same directory (and this will always be the case). Suggestions?
View 2 RepliesI need to code the following:
1.Connect to an Oracle database.
2.Execute a query.
3.Insert the query result into an Access database table.
I�m able to solve points 1 and 2. how to code point 3?
I need to code the following:
1.Connect to an Oracle database.
2.Execute a query.
3.Insert the query result into an Access database table.
I have a folder C:databases and in that folder there are subfolders C:DatabasesDatabase1 and CDDatabasesDatabase2 What I want to do is have a VB script or code that will go through each directory and make a copy of all .mdb database files found within the folder or subfolders of C:Databases.
View 4 RepliesI'm creating a database backup function into by program which will allow the user to locally backup a database to the selected folder. How do I go about doing this? I realise you cant copy an open database, but I cant think of any other way to do it.
View 1 RepliesImports System.IO
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
but alwys i get thie error access to the path e: is denied but the hard drive is accessable, so how i copy a fil from resource to a a disk drive like F: /
Here is the:
Imports System.Data.OleDb
'Add reference to Access then
Imports Microsoft.Office.Interop
Imports Microsoft.VisualBasic
[CODE]...
I am using this to copy tables in an Access database(2003). the questions I have are:
1. How can I make this more 'obejct oriented'?
2. How can I copy just the structure of the tables and not the data?
(Currently both are occuring)
I have two MS Access database; Mydb1 and Mydb2. I would like to do the following:
1. Copy all records in table (MyTable1) from Mydb1 to Mydb2. MyTable1 also exists in Mydb2
2. Move all records in table (MyTable2) from Mydb1 to Mydb2. MyTable2 also exists in Mydb2 which needs to be flushed.
I encounter some problems when doing coding of backup file by copy and paste the database(Microsoft Access File) to another directory. Example, textbox1 will show the path of file that I want to backup, textbox2 will show the path I want to copy to. I need 1 button for browsing the file and another button for make confirmation of the path that I want to copy to.
View 2 RepliesI am able to copy the complete online mysql database to the local ms access database, but the problem is that the local database needs to be emptied before the new data is being copied.And a progressbar needs to display the entire progress.Here is the code what I have now:
[Code]...
I'm trying to make a file.copy to the program files folder but can't get access to it.This is on windows vista and 7.
View 6 RepliesI'm using the code from the following site to create a file manager within my app: [url]Which, I think is great. When I first started programming, I wanted to use this code, but I couldn't understand it. I love how now, I understand most of it and know how to implement it. Which, I owe much of my progress to some of you at this site Well, back to what I was saying. I want to be able to make a right click menu and have it access options like copy, paste, etc. I'm sure I can figure that out, but I can't seem to figure out how to make a right click menu.I thought I could manipulate a menustrip, but I wasn't sure how.
View 3 RepliesI am able to copy the complete online mysql database to the local ms access database, but the problem is that the local database needs to be emptied before the new data is being copied. And a progressbar needs to display the entire progress. Here is the code what I have now:
Private Sub StartScreen1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dt As New DataTable()
[Code].....
I need to copy my SQL Server DBs to a folder. The files are attached to SQL Server, which I have detached using my code. When I try to copy these files using My.Computer.FileSystem.CopyFile(filePathToCopyFrom1, targetFilePath1)
[Code]...
I got a problem...after load crystal report viewer, I am unable to right click->Copy or ctrl+c and copy any text. I am using vb.net 2005, crystal Report 11...I am showing the report content on the Report Viewer..
View 4 Repliesi am mukesh i want a form were i have a button now i want to copy what ever i still now changes made in a vb.net from to be stored inside the pendrive just by clicking on the button does it possible i have done a project which is a shops project now my client wants to do that project when he is in shop he will use it in laptop but when he moves to some other location he wants to carry that project in a pendrive since he is not so much educated o he needs only one key which he must press to copy the database from my source my documents to the pendrive does it possible
View 1 RepliesI have a weird behavior when trying to copy a file with System.IO.File.Copy. The file never gets copied. More than that, the call doesn't generate an exeption!
I am using VB.NET, Framework 3.5. I'm trying to copy in C:Temp and I do have the privileges. Or at least I used to...
The triangle that is. I copy it and it pastes 4. Want to copy it to my richtextbox
View 11 RepliesWhen i copy a table into DataSet is it possible to copy its index's as well? right now i add kinda big table (250k + rows) into dataset and i need to query that DataSet table in my application, the problem is that in some quires it's getting slow.what is the right approch to solve this problem?
View 6 RepliesI want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
Here Is my code
Public Sub MoveAllFolders(ByVal fromPathInfo As DirectoryInfo, ByVal toPath As String)
Dim toPathInfo = New DirectoryInfo(toPath)
If (Not toPathInfo.Exists) Then
toPathInfo.Create()
[code]....
My goal is to move all folder inside a folder into a folder named Folders.so If I do it on desktop all the folders in desktop will go to "Folders"but I get an error "The process cannot access the file because it is being used by another process."
As I understand it a shallow copy is like a CLONE copy of an object where the values for each property are independent of one another whereas a DEEP copy is a copy that uses the same memory locations and therefore if you change a value in one it is also shown in the second item ( By Reference to the same memory locations ).So my main question is, when dealing with CLASSEs, STRUCTUREs etcetera containing REFERENCE types.is there anyway to quickly create a CLONE or shallow copy of an OBJECT or not ? The only way I can think of is to put the item into a one dimensional array and use the CLONE method for an array. [code]
View 9 RepliesWhen I load my solution and compile it after first starting the IDE, everything works as expected. After changing source and recompiling, I get the following compile error:
Error 11 Unable to copy file "objDebugCAMDRS.Library.dll" to "binCAMDRS.Library.dll". The process cannot access the file 'binCAMDRS.Library.dll' because it is being used by another process. CAMDRS.Library.
After closing Visual Studio 2005 and reopening the solution I can compile again successfully. This is an old solution that has been fine for a long time. I just recently changed computers and reinstalled everything.I am running win XP Pro sp2, Visual Studio 2005 sp1.
i'm having problem with rebuilding my program. Everything went fine when I run my application but when I stopped and made some changes to it and re-run it again this error message kept on displaying "unable to copy file "objelease" to "binelease". the process cannot access the file because it is being used by another process"And when i run task manager to kill the process and re-run the application it went fine b
View 4 RepliesI have a backup class it copys every thing but the unmovable files witch in return when i test the dive that i just backed up all files to will not boot up missing win system32 config files??how would i add permission to my code??? or how do i over ride cant copy file because a nother process is useing it?
View 3 RepliesI have a program that uses IO.File.Copy to copy files from point a to point b. Its slow, which is fine because there rather large files. I was wondering if there is way to get an estimate time to copy a particular file(s).
Example: File a will take 1 hour to copy, File B will take 30 minutes to copy. Estimate Total Time: 1 hour 30 minutes.
I 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 Replies