VB Forum / Database Access / October 2004

I created a SP with SQL that processes the number of records in a table for a
particular State, The Query works correctly. This is it:
Create Procedure CountRecords15 @SearchStr varchar(10)
AS

Hi, my cordial regards, I'm havin' a dreadfull problem programming with ADO
You'll see, I want to update a record, but it's allways the same message (
err code: 3251 )
"Current recordset does not support updating. This may be a limitation of

Hi To All
I am trying to make a sql(access) query  through my vb6 small app but with
out any result.
Here is my DB.

I've been using ADO for a few years now and now I need to simply open
an access DB using DAO3.6 which has is password protected.
set dbtemp = opendatabase("MyDB.MDB",False,False," ;pwd=mypass")
I get an error about "cannot find...ISAM" something, something...

I have a vb app that generate report linked to crystal report, problem
comes when trying
to run the report, when press for debug an error message that says
"run-time error 424:

I used to access database in VB6 using VB data environment.
I would get a specific cell from the database using such langauge:
dataenvironment.rsTABLE.fields(1).item(0).value
I have now moved to VB.NET, and have connect my DB to my project using the

HI. I have a dataset with two tables. Table 1 is parent and table 2 is
child. Am populating a single datagrid with records from child table
derived from a single parent record. I am then allowing users to edit
child records in datagrid. Users have an update option for each row in

     I created a macro package for authomating MailMerge in MSWord 2003 the
program worked fine but the problem that I am having is that during
mailmerge process as security warnning popup("openning "D:\MyDB" This file
may not be safe if it contains code that was intended to harm ...

I created a script that queries a database and sends a mail.  It worked fine
when I tested it on my own email address, but when I run it programmatically
to emails that come from the query, for some reason it went 5 times!!  I'm
certain that didn't make the other people very ...

How do I get the message that would result from a query?  For
instance, if I run a query in Query Analyzer like "SELECT * FROM
TableName" I get back a grid of results, in VB I would get back these
results as a recordset.  Other queries would just produce messages and

I know we can repeat SQL statements with ; between each one then execute it
once. Is there a limit like how many ; I can put in or is it limited by
bytes?
Thanks

Hi, first off, to introduce myself, I'm only exposed to VB for half a year
and am supposed to do a project on it. I'm 18 this year, my name is Ray.
Just thought it'd be polite to introduce myself since I'm new. Thanks.
Alright, now for the questions.

There is going to be a button that has alternating text on it
depending on 2 choices the user can make.  How do you show button text
to say Add Package if the database says there are NO package items
associated with a certain product.  And if the product has package

I'm opening an ADODB connection to an SQL database in VB6 using the
adModeShareExclusive mode for the connection object.  The connection opens
successfully, but I'm still able to modify records in the database using
Enterprise Manager.  Why is this?  I want to open the SQL database ...

What is a stored procedure?  Is it like a Query in an Access Db?
Any benefits to using this versus a standard SQL query?
Perhaps a link to a tutorial.