Search results for query: *

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...

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, 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, 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...

Hi, We have a product written in VB 2005 that uses Acesss DB to store date from mainframe processing. Currently we are using the Jel.OLEDB 4.0 with engine type 5which are Access 2000, I believe. Our concern is drop support for this particular Jet Engine. The question is do we need...

Hi, We have a product written in VB 2005 that uses Acesss DB to store date from mainframe processing. Currently we are using the Jel.OLEDB 4.0 with engine type 5which are Access 2000, I believe. Our concern is drop support for this particular Jet Engine. The question is do we need...

Hi, We are in the processing of converting ADODB to OLE DB Access 2000 databease for .NET. We have encounter some performance diffferences; can anyone tell me if OLEDB takes more overhead than ADODB. Thanks

Hi, I am having a problem trying to use transaction for updating my Access databases. I used both transaction and no transaction and I get the same run time. Below is a sample of my code with transaction processing: Dim Transaction As OleDbTransaction = cnnNew.BeginTransaction...

Hi, I have a need to find field attributes in a table, especially length of field and name. This information is needed for a common routine for printing reports from a table. I am converting ActiveX to .NET OLEDB and the current code is: 'ReDim arr(UBound(arrColumnName))...

Hi, I just ran across an interesting problem when doing the above conversion. In our old ActiveX we defined our fields as adVarWChar, now OLEDB does not accept adVarWChar, so I used advarchar. I am getting different results. With adVarWchar if you move "Rev Trks" to a field define...

Hi, I am updating a DLL from ActievX to OLEDB and I am having a problem with a field that needs to be defined with auto increment. I get an error messenge, "Syntax error in CREATE TABLE statement". Below is a portion of the code: strSQL = "CREATE TABLE tblCdd (" & _...

Hi, I have a form that can display multiple data grids. There can only be one grid active at at time. I need to know what grid is active? Any ideas?

Hi, I would like to create a table using the For/Do loop because the table name is similar except for the last postion which can contain values 1 to 4. Below is my current code: strCMD = "CREATE TABLE WEEK1 (" & _ "TGSN varchar (8)," & _...

Hi, I am in the process of converting ADODB to OLEBD and I need advice on how to create an index for my datebase. Below is the code to create the database: strCMD = "CREATE TABLE SelCrit (" & _ "TRENDING_METHOD varchar (1)," & _ ...

Hi, I need to retrieve the columns for a particluar data table in a dataset. I was able to find code to process data tables in a dataset but can not find how to process the columns for a table. Below is my code: Dim dcDataColumn As DataColumn cnn = New...

I am getting a message of "Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'." The insert is quite lenghtly sixty one fields. Below is part of the code: strInsert = "INSERT INTO tblResults ([Update Resp code], [TF Resp Code], TGSN, Update500...

Hi, I have a INSERT to an access database that has about twenty fields. Is there anyway to continue the INSERT statement instead of making one continous statement as below: cmd = New OleDbCommand(" INSERT INTO tblRevResults ([Update Resp Code], [Check Field], [Save Ind], [TF Resp Code]...