VB Forum / Database Access / February 2004

I have written an application that queries an MS Access database. It seems
to work fine when installs on a windows 2000 machine and XP machine but not
on a windows NT or Windows 98 machine. The program installs OK but when it
goes into various pages it gives the following error:

If an Access 2002 .mdb file is password protected, how can I start an
instance of Access 2002 from VB6, passing the password from within the
program (prompting for .mdb password does not work, as the app user does not
know the password)?

Dear Sir,
How I can Create Empty Recordset with required fields in which I can append
data Using ADO.
Please give me link where example is there.

Hi Again Group,
Sorry to trouble you all again but i`ve been looking at this problem for 2
weeks now and just don`t seem to be able to grasp how to create a
relationship in VB.NET with ADO.NET.

We are adding records through an ActiveX DLL in our VB6 app using a Command
(INSERT).  Once the record is inserted, we close the ADO connection, set it
to "Nothing", then exit the DLL to our main executeble code, which
immediately retrieves an ADO recordset of the related records to ...

I can't get a datagrid to display an Access boolean (yes/no) column as a
check box, even though the datagrid has a check box format option. It just
displays as either a 0 or a 1, not a check box.
Any thoughts, anyone?

I have written an application that queries an MS Access database. It seems
to work fine when installs on a windows 2000 machine and XP machine but not
on a windows NT or Windows 98 machine. The program installs OK but when it
goes into various pages it gives the following error:

Hello World, I need to sort a dataset so I've copied a datatable from the dataset and then use the Select command to do the sorting,  BUT, I'm not successful in Updating the database with the revised (sorted) data after I have deleted all the rows.  In fact, I can't even get the ...

I have a oracle function with 2 input params. One of then is a ref cursor:
PACKAGE.FUNTION(param1 IN VARCHAR2, param2 IN types.ref_cursor)
I need call this function from Visual Basic 6.0, passing a recordset param,
but I don't know whitch data type I have to use:

Im new to VB and I wonder whether it is possible to programmatically create
a microsoft acess database using VB.NET. I already know how to update tables
of an existing database, but I didnt find any info on starting a database
from scratch in VB.NET.

That's the thing: I have a data source only accesible by means of DAO.
Don't ask me why because I don't know. Someone decided it would be
better not to let us another kind of connection :(
I'm trying to do a 'conversion and move data' utility. I have the part

Im runnibg VB6 ( SP5) and SQl 2000
I have been trying to generate a stored procedure to insert a record into a table and return the @@rowcount to the vb applicationto verify the insert happened.
CREATE PROCEDURE TESTINSERT
        @Licence Varchar(6),

I am working with tables and queries. I need to add some and delete some.
Anyways, I am using an example from MSDN article 129927 and am having a
problem.
I can get a table name if it exists but I can't get any query names.

Hi - I don't know what to look at ?
I have a DLL with a couple of classes. An external appliacation calls the
first class in the DLL, this in turn displays a form which calls another
function in the external application. This other function calls the second

I'm able to use SQL DMO to get a list of Views for a Database:
   For Each oView In oDatabase.Views
       If Left(oView.Name, 2) <> "dt" And Left(oView.Name, 3) <> "sys" Then
           Set nodX = tvwTest.Nodes.Add("ViewList" & "." & strServerName &