Search results for query: *

Mark, Thanks for your reply. I did some research and it is possible I can use the SqlBulkCpy but im my case with Column Headings. I do have a question, can I use this command to load the date to a Microsoft Access data base? Thanks again, Fred

Hi, We have a process that loads a Microsoft Access database. The software is written in VB 2010 32-bit and using OLEdB. The software runs on Windowds XP and Windows 7. My concern is the amount of time to load the database. There are seven tables and the amount of records inserted depends on...

Hi, I am converting an old Installshield project and removing old ActiveX or OCX DLLs. When I install on a PC and test I get the message, "Cannot create ActiveX component". How can I found out what component it is referring to. I can't install VB on the PC so that opion is out! Any ideas...

Hi, I am trying to find out if there is an end of life support for the MS Jet Engine. It is my understanding with the release of 2007 Microsoft Office, Access uses a new file type. We are trying to figure out if we need a conversion program to convert our existing db's or we can...

Hi, thanks for all the comments. I changed the code around and it solved my problem.

I am running into a problem when trying to DROP a table. I get a RTE saying the table is being used by another user or another process. The process is to print an Access table it works the first time but if you try to print immediately print the table again is when the RTE occurs. When the...

I am running into a problem when trying to DROP a table. I get a RTE saying the table is being used by another user or another process. The process is to print an Access table it works the first time but if you try to print immediately print the table again is when the RTE occurs. When the...

Hi, Thanks for your help, the process works great. I am sorry for any inconivenace I may have given you. Fred

Hi, I am sorry about the mix up on the code, trying to do things to quick. Here is the procedure of code with your last suggestion: Private Sub btnAddRow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddRow.Click Dim StartTime As DateTime...

Hi, sorry, so here is the code: Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\TestDataAccessMethods.mdb;User Id=admin;Password=;") Dim da As OleDb.OleDbDataAdapter Dim dset As New DataSet Dim Sql As String...

Hi, Also, on the same line: dsNewRow(0) = "hello everyone"

Hi, I tried both methods you suggested and got an exception both times. The first suggestion when I typed in the code "dsNewRow." there was no "Item" from the list for dsNewRow object. The second suggestion I got the exception,"No default member found for type 'Object'.

Hi, I need to code a function add rows to a dataset from a text file. I have not used the DataRow before and I am running into problems. I get the message "use the keyword new to create an object instance" when the statement, dsNewRow = dset.Tables("Table1").NewRow() is executed. When I...

Hi, I think I find the problem. Riverguy, I took your code and ran it, made changes and I believe the problem is in the With/End With. I do not understand why but the time I am getting is no where the time you were getting with you code. Below are my changes and the performance increase...

HI, I tried with the transaction and I DID not get an improvement in time. It took about7 mintues to read 22,000 records and insert them into a table. Below is my entire code for loading this table, it is quite extensive because of the number of fields. I must be missing something...

Hi, I tried using Transactions and the time did not improve. Below is the actual code for updating one of the tables: <Start of Code> Dim Transaction As OleDbTransaction = cnnNew.BeginTransaction Do While more_record strSQL = "INSERT INTO FI(" & _...

Greeg, The data is coming from a file downlaoded from a mainframe. The input file is read and then the table is populated. Some fields are checked and certain values and replaced in the table. I am not sure what you mean by "Import".

Hi RiverGuy, Sorry for not getting back to you sooner, but yes there is a DO LOOP to read the records. I noticed you experience a big difference in processing. Happy to head that because it confirms out test results, but sorry for the client who will experience increase processing time...

Hi, The original code was also in VB 2005. Other than using OLEDB the new code was wrapped around a Using - End Using. Here is a snippet of the original code: mytable.AddNew() mytable.Fields("TGSN").Value = Downloaded_Rec_SPH.tgsn If...

Hi, We are converting our application to use to OLEDB from ADODB. The application is written in VB 2005 and storing data in Access tables. Our problem is after writing the code and started unit testing we notice a big hit in performance. Below is a snippet of our code: START OF CODE...