VB Forum / Database Access / December 2003

I have a datagrid with a DataGridColumnStyle object that
shall show a commentfield. The comment field may have
several rows.
How can I make the data grid to automaticly ajust to the

I  need to highlight the first item within a ListView row programmically
after it is filled.  I have the FullRowSelect property set.
How do I go about doing this from within my code?

I am creating an aspx page to show (i.e. read only) hundreds or probably
thousands of items from two database queries.  The user may of course only
want to read one or two pages worth.  I have (I think) two possible
solutions:

when i mark the OpenRecordset in
set temp=db.OpenRecordSet (sqlstr)
i get the above error from v.b.
when HELP msdn lirary notify:

Here's a Thanksgiving riddle for you all.  It's a doozy, and we've
been struggling with it for over a month now.
We have a custom VB 6 application that was developed on Windows 2000.
The decision was made to implement the application on Windows XP Pro.

OK this is my first attempt at VB.Net and i may be biting off more then I
can chew, but here it goes...
I am looking to develop an application that will run with either SQL, DBF or
Access tables for its data source.  The idea is for the user to identify

Everything works fine, only exception is when there is no
record return by the given where clause.
Error Msg
(-1 of 0) Operation is not allowed when the object is

here is my problem
when i use the adodc1.resouce method to change the query
and run the program I get an error message that operation
not allowed and adodc1 is already open something like that

After runnig following script, I get the error in the subject.
All I want to know is does a specified table exists.
What am I doing wrong ?
THX , Bas

This should be simple but I'm not sure what's the easiest
way.
I have a an ADO Recordset that I want to copy into a SQL
Server table

I am using SQL statements to pull info to and from my MS-
Access database (Access 2000) using VB6.  I noticed that
when I am trying to insert or add a memo field (or any
text field for that matter) that contains a "'" (squote)

I want to lock a row in a database table in such a way that no other process
can read that record. Process some VB stuff for a few seconds. Update the
locked row. Then unlock the record. (Language = VB6, Database = SQL Server
2000, Data Access = ADO)

Hi Group,
Anybody know of anywhere where there is a tutorial on building a Simple
Helpdesk in VB?
Ta

I'm going to be writing a new VB6 app that uses Access 2000 database.  I
have prior experience of using DAO 3.51 for Access 97, and using ADO for SQL
Server 7.  But I have no experience with using ADO for Access 2000.  Should
I stick with DAO for Microsoft Access, or move to ADO?  ...

Thank you in advance. I am trying to store an encrypted password in an SQL
Server 2000 database. I have a few questions on doing this.
1. I think the data type for the column needs to be binary. Is this correct?
2. How do I get the encrypted string to binary?