VB Forum / Database Access / January 2004

Can anybody tell me the method or give me the link to a code which shows how
to create an Access Database from scratch?
Thx,
Nayan

I'm new to ADO. My past experience has been with DAO. Well, just recently I started using ADO in my Visual Basic 6.0 applications. I've had no problems until now. When I tried to mix ADO and DAO references together in the same project, my problems began. In other words, I ...

How do I change the bg color of the selected row for msflexgrid?
I need to at least highlight the row when the user clicks anywhere within
the row, and display the value in a certain column to a textbox.
Currently, this is what I'm doing.. but the highlight goes away the moment I

I am trying to save data in a database. Below is the code I have written, but I
keep getting error messages like (run-time error '3219' Operation is not
allowed in this context). This is in reference to rsDriver.close, when I delete
it another error message ( run-time error '3705' ...

Ok, I have a DBGRID, I want to fill this grid with information from two
differnt Databases(not differnt tables) how would i go about doing this?
Both are access databases. Oh ya, this is using the DATA component not ADO,
how i would love ADO but the rest of the program is in DATA, I ...

Hi ther
I am trying to read the content of one Oracle Long field
I am accessing an oracle database through its native interface (ODPNET) and when I get to read this field out of the table I get problems
I am supposed to use the "GETORACLESTRING" function, which requires an ...

You can all have free copies of adoanywhere browser at the link below.
The browser opens ADO based connections then displays all ado properties,
methods & events.
GUI support for Transactions, OpenSchema , ADOX, Batch optimistic locking ,

I am simply trying to use VB6 as a means to display information in an
Access 2000 table. I don't need to be able to update the Access table
at this point...just view the info in it. I am using an ADODB
connection with recordsets and use the rs.MoveNext and rs.MovePrevious

I have a VB6 program that is simply a means to display info in an Access 2000 database. No modifications are made through it. I can get it to display everything correctly using a recordset and an ADO connection except for the check boxes. In the Access database I have 2 ...

I am using ODBC 3.51 and mySQL 4.0.1-NT.   I have an app that is written in
vb6 with msAccess 2000 that was converted to mySQL.  Everything is working
great except for one thing.
I have a grid of information (using TrueGrid v7) and I need the grid to

I'm trying to bind my parameters when creating my SQL statements for an Oracle DB using ADO.  Character data is fine (adVarChar), however, when I try passing numeric data (adNumeric)...it does not seem to work
Any suggestions?

I have a picture field (OLE object) in an Access db.  I'm trying to read that pic from a VB 6 app and display it in an image object.  Anyone know how to do this?  Thanks.

I am able to create SQL statement bound to a DATAGrid  or a list box  no problem
just I have  level 101 question ?
how can I dispaly the result of this statment  to a textbo
strSQL = " SELECT  SUM(AMOUNT) FROM TBL_VALUE

I'm trying to convert an existing system build on Interbase to SQL Server.
The triggers written in that are giving me some problem. There has been a
syntax used as NEW.<Field Name> in the interbase DB. This is actually
written on "AFTER INSERT" of table, NEW.<Field Name> gives the ...

I would like to know how to get the ODBC driver list (the one which is used
to create a new DSN in Administration Tool->DataSource ODBC) to populate a
list in Visual Basic .NET.
Is there anyone who can help me?