Vb6 current recordset does not support updating

Hi everyone, here is a small gift to everyone out there who has given their time to answer questions. There are still a few bugs, but I hope it helps save some time for someone. Note: I am not a programmer, so asking me technical programming questions is probably be a waste of time. I am sure there are more efficient ways of doing things than shown here. Will :-) ################################################### #################### Form_frm CONSOLE ################## ################################################### Option Compare Database Option Explicit '------------------------------------------------------------------------ '--------------- SETUP INSTRUCTION - My SQL SERVER SIDE -------------- '------------------------------------------------------------------------ ' CREATE TABLE - ALL (SELECT tbl MSA.

When both libraries are referenced and both libraries support an object, VBA will assign the library with the highest priority. Explicitly referencing each object's library when you declare the object is better: Moving through the records in a Recordset is a common task, but doing so comes with a few hazards.

To connect to a specific database, the consumer is required to set the following properties of the Ora OLEDB is compatible with OLE DB Services that are available in OLE DB version 2.0 and later.

OLE DB Services contains useful services such as automatic transaction enlistment, Client Cursor Engine (CCE), connection and session pooling, which can enhance application performance, and others.

OLE DB Services can be used with Ora OLEDB through C /COM or ADO.

By default, the For C /COM applications, some additional steps are needed to use OLE DB Services.

'- OLE DB PROVIDER is considered obsolete by Microsoft from Carl Prothman '- Carl ---- Beautiful library of connection strings '------------------------------------------------------------------------ '---------------------- CONNECTION OPTION #1 ------------------------- '--------------ODBC FILEDSN connection using My ODBC Driver ------------ '------ File DSN files are Stored in a Data Source default directory --------- '------------------------------------------------------------------------ 'conn.

You must have an account to comment. Please register or login here!