VB Forum / Database Access / May 2006

I have set up a SQL for search data in an Access Database in VB.
My SQL looks like : Select * from [MyTable] where [FieldName] Like 'ab*',
but it fails in running the program.
I wonder if I use an incorrect syntax. However, I have perofrm the same

Does using a With statement speed up code within an ADOBD recordset?  I know
the With statement speeds up code by qualifying the object only once but
wasn't sure if it makes a difference within an ADO recordset read.  For
example, would the code example below run faster using the ...

I have an Access db and use ado 2.8 with vb6 to list records. I usually set
a limit (ie TOP 1000) to get the first 1000 records and list those in order
to improve performance.
I was wondering... would it make much a difference in performance if I get

I'm executing a select statement on an Access database.  One of the fields is
a datetime field.  I would like to retrieve both the date and the time, but
VB only seems to return the date.  Running the query in Access gives me both.
How do I get the time executing the query from ...

I am using DAO v3.6 in a VB6 application, running against an Access 2000 db.
I create a new field in an existing table using the following query:
sSQL = "ALTER TABLE MyTable ADD MyNewField long"
MyDAODB.Execute sSQL

I am testing a VB.NET application using SQL Server Express (2005) and
ADODB.
Multiple instances of the application all access the database. In some
cases, they access and try to update the same row of a table. I am

Hi Friends,
I want to Append / Write some text (Content of some small text file having 2
lines: Ex:- "MyText.txt" having 170 bytes of DATA) in one of the EXE file
(Binary File) Ex: "MyApplication.exe" using VB.

I send the following query in batch using ADO command object,
UPDATE Table1 SET Amt=9
UPDATE Table1 SET Amt=9999
UPDATE Table1 SET Amt=99

From a VB6 command button, how do I copy an Access table1 (&records) to
table2 (both in the same db) then delete all the records from table2 where
[Wk] >5 then provide a count of records in table2. The Access db is named
Spelling.mdb (I would appreciate additional example line of ...

Is this possible? Or is the functionality available only in the full blown
version?
Thanks, Dean.

I have little knowledge of databases and am struggling with several problems that are not shown in
any of the texts that I have.  I have VB6 SP6 enterprise edition, XP home edition and using DAO 3.6.
I have tried to use the following to update/edit a single, existing record, but ...

I am fairly new to the new DB.  I have an app that connects to a SQL
database.  What I would like to do is:
Store the SQL Server and DB name in a registry key
If the registry key is not there, or user would like to connect to a

We are having a problem with extracting files from our sql 2000
database. All files are either MS word .doc files or rich text files
rtf's. In an attempt to reduce the size of our database we're going to
compress the files in the database (almost 1 million) by extracting the

Wondering if there is a better method to open the DB connection.
A little background......
Just for testing, I have a form with two buttons as follows:
   Private Sub btnConnect_Click(ByVal sender As System.Object, ByVal e

Hi,
I downloaded .NET Framework Version 1.0 Data Provider for Oracle and I have
visual studio .Net 2003, but after installing the file oracle_net.msi nothing
happened. I still can't use