VB Forum / Database Access / November 2003

My ADO recordset is not open but there are no errors from
the open or anything else. The Connection is open. Iam
calling stored proc and there is data. I have used a VB
program to verify that the connection string. I am able to

I develop an application in which i use a datagrid control
with an ADO control. The problem I have is that when i try
to add a new record using datagrid and then i try to move
in another row in datagrid i take a runtime error.

How can you set the timeout on an ADORecordset?
I know that you can set a timeout on the ADOCommand object
but have not seen a method for a recordset.
I've tried something like whats shown below without

I'd like to make the following thing :
I've got a VB6 project based on MDAC 2.7 library.
I've got a main database DATA_SYS.MDB located
in C:\TMP\DATA_SYS.MDB

I have a problem here. Hope some of you can help me out.
Sorry for cross posting, because I find that there's more response from this NG, but yet I want to post it to crystal NG also.
I'm trying to pass 2 parameters from VB6 to crystal report.
The follow is my code:

Is there a way in VB5 to Transfer text directly to a txt file? (Similar to Access DoCmd.TransferText)? Any Ideas?
Sudha

Does anyone have any sample code they could assist me
with. I want to lock a table before I can write data to it
so no one else is able to use that table. I tried using
the LockType command but I am not getting the results that

I looked at Microsoft's DLL lookup. The DAO360.DLL version 3.60.3714.5
has different sizes on Windows 2000 and Windows XP.
Are they same?
Can any of the file be used on both platform?

I am getting the following error when I try to execute an ADO command
against an Access DB.  This is the error...  "No value given for one or more
required parameters."  This is a direct SQL statemtn that I am trying to
execute.  It is not a stored query.  Below is a copy of the ...

I would like to code my data access component to be SQL
Clustering aware. Does anyone have code or links to
help me?
Thanks

I have this statement which works fine when txtfields is a string
adoPrimaryRS1.Open "select * from tblTroubleLog where TLogRecordID =
'" & txtFields(0) & "'"
txtfields(0) had to be changed and is now numeric.

So I am fetching from a Sybase Table using Select statement. So I open a
connection using a recordset to do all the select I need. When I execute my
program, everything works well untill I get this message error :
"General Error: Ressource governor for prepared statements exceeded"

I am looking for a way to take some data out of my Database and display and
print them in a nice looking way.
It first sounds like a job for Crystal Reports, but I need something that is
free, because I do not have a license for CR...

after updating a record you need a certain time(a few seconds) to reaccess
the record.
This is a known issue, but i found no solutions for this.
I'm using vb6;access97; ado;4.0

I don't know if this is the right forum. If not, please direct me.
I'm very new to programming for VB.net and never performed operations for
Access.  Not a good combination apparently.  This is what I am looking for:
I need to use VB.net to: