VB Forum / Database Access / April 2005

I have a ado Data Control on my form. I want to set the connection string on
form load.
So my database is players.mdb. So I set the string in the design properties
to C:\Test\Players.mdb

I have a VB6 ADO app which works fine on XP and W2K, but generates Dr
Watson crashes (Exception number: c0000005 (access violation))on NT4
workstation (SP6, MDAC 2.5).
Code snippet:

Sorry if this question has been asked before, but I can not seem to
move to a database record, when I click on a listbox item.
Here's some basic information:
---------------------------------------

I call a Stored Procedure(SQL-Server) from my VB Application
and showing process on a progressbar.But  I don't know how much time taken
by SP.
That is why I cannot show Progressbar value propotionately.

I use a DSN (Access driver ver 4.0) to connect to my
access DB.
I try to update a field using Recordset.Addnew. This field
is a memo field. This generates the error

I have manged to get my program to the point where it does everything i need
it to.
The only problem is that I need to password protect (or protect in someother
way) the Access file.  The reason for this is that it needs to be

Is this possible?  As access always creates the *.ldb file is there anyway
round this.  I only need to perform queries on the database being used and
nothing is to be edited.
Any ideas?

Not sure exactly how to explain this - still learning... I have a database
that keeps track of income and expenses - database name is mydatabase and
recordset is mydatabaseinfo.
For sql queries I use various txt strings depending on what I'm looking for

OK, Ive got VB6 and an Access2000 DB connected through the
DataEnvironment Designer.
In VB6 I want it to select a row from an employee table based on the
user that is logged in.  I know to use Environ("Username") to grab the

I'm a student of VB, familiar with Access & VBA.
I have a simple VB data form which the Data Form Wizard created(using an
existing access.mdb).  It displays a customer list, Name, Address, City &
State.  I can only scroll through the list sequentially using the arrows of

Within VB6/ADO 2.5 I access a column with type TEXT but
it only shows me the first 6/7 lines of text not the 20
or so expected.
Column TEXT can hold a lot of data but is limited by some

I was wondering if there was a way I could call a function from VB6 to fill a
listbox/combobox with all the views I have in a database?

Can anyone please help with a problem.
My application uses an Access database and if I use my exit buttons setting
db to nothing the database
is closed down correctly.

I am using ado control to connect to a sql  2000 db. I have several data bound
controls on mdi forms and they all work fine except for a label control that
is bound to a field with a datatype of varbinary . The field actually contains
0x0029B892FB3879144EB5ABE64CF067BE4B0E but ...

I have the following code in my program, if a user tries to add a record
that already exist it it produces the appropriate error message. the problem
is that after the error I can't add another record without first closing the
form and open it again. Is the a way of doing it ...