VB Forum / Database Access / November 2006

I am having a password protected excel file which have some data in it.
I trying to open the file through my VB 6.0 application using ADODB
connectivity method and i am passing the password in pwd parameter.
But i am getting an error messge saying ( -2147467259)

All,
   I am creating a recordset by code using VB6 and appending fields as a
result of processing a recordset that contains two columns that have a
key/pair relationship. For example, I have two recordsets rs1 and rs2 and

I have an Access 97 database and wish to migrate the back-end to SQL
Server.
The back-end has a field that contains a Word Doc stored as an OLE
object.

hello every body!
i have a probem with counting a field in my table an then displaying
the result.i need your help.
so i got a table "vct" wich has 2 fields ("vct_name","result")

All Certifications Like
MICROSOFT,CISCO,COMPTIA,SOLARIS,ORACLE,SAP,MICOSOFT BUSINESS
SOLUTIONS,EMC at your doorstep without exams..and with 100% passing
guarantee...No need to go to any testing centre...we will do everything

Thanks in advance for your help. I know you all do this on your own time
and it is greatly appreciated.  I am just starting to learn vb6 and was
wondering how vb handles the relationships set up in an Access database
when you are inserting data into it.  I realize you are using ...

I need to edit fields in a record set that is partially pre-loaded.
In Access it's pretty explicit Edit->fld("a") = newdata->Update, but
I cannot figure out how to do this simple task in SQL (from VB6).
I open a recordset (dbopentable) and do a find for the record in

I am trying to move from Access 97 database file to SQL Server Everywhere in
VB.NET
I have code in VB.NET that builds the required tables in a new SSEv database
file but am stumped at not being able to detect if the Access field is

I have a question, please give me some idea. Thanks in advance!
Solution1
   |
   |---DBLogic (class library)

I'm using ADO classic with Oracle 8/9i (both display same symptoms).
I can open a recordset using a sql statement against a table that is
addressed via synonym.  The primary key field has the property
"KEYCOLUMN" = FALSE if I address the table in the query with it's

Hi all, if anyone can shed some light on this I'd be very happy!
I have an large application which uses the DAO version that is loaded on the
users system (normally 3.6). There are currently over 300 users of the
application and it  would appear that the majority have no problems. ...

What bastard is this? I connect to a MySQL database.
Sub SwitchQueMode()
 Dim wrkODBC As Workspace
 Dim conn As Connection

I can connect to the database manually, by starting it and entering my
login info, but I still get that error.
Here is my code:
Sub SetUpConnection()

I'm using VB6.0 and Access 2003
I've always written vb applications that use access databases that have
resided on the local C: drive.
Compact on close has always been great in this arena.

I get the error "No value given for one or more required parameters" when
running the following function.
The error occurs at the cnDB.Execute strSQL line.
What's odd is that if I run ?strSQL in the debug window then copy/paste