VB Forum / Database Access / April 2004

I converted a VB 6 program from using DAO to ADO to create an Access
2002 database.  The resulting database built with ADO is *huge*
compared to the one built with DAO -- 15 MB vs. 460 KB -- using
exactly the same data.  When I open the tables in the two databases,

I've got an app which uses sql dmo to connect to sql server databases on the
remotely
I always start out with :
   Set oServer = New SQLDMO.SQLServer

I've got an app which uses sql dmo to connect to sql server databases on the
remotely
I always start out with :
   Set oServer = New SQLDMO.SQLServer

in a vb6 app if an access97 mde table is selected into a recordset with
ado, what is the easiest way to
append this information into a sql table which is exactly the same except it
has one additional field for a timestamp

I use JRO to mdb database compact in VB6 programm.
In VB.NET is JRO to mdb database compact ?

I am trying to get some results back from a JET Database (Access 2000) and
I'm having problems composing a SQL statement to work as intended.
An earlier statement is added to as the user tweaks more refinements to the
results he wants back.

Is there a way to delete a field in an open/closed recordset
TIA
Eric

I can't open the tabe, anyone know if I have miss out anything??
thanks
Dim db As Database
Dim rs As Recordset

is it possible to write a visual basic application that runs directly from
cd and reads a database (also stored on that cd) without making an install
necessary ?
The database would contain user information about a club. The purpose is to

I have a newbie question about OLE objects.  Recently, I was assigned
a task to extract images stored in an Access database to files.  The
images bitmaps stored in OLE object format.  Can somebody point me to
the right direction?  Or a code snippet if possible?

New to VB and having a problem retriving data from multiple database
tables (access 2000). To put it simply I have created 2 tables
(employee and sales) which are linked by a common empID field. My
first VB form allows the user to navigate each record, create and

Can I issue statements like "create database my_db" from VB .NET code to create an Access database
Please help
Thanks.

I am getting a very bizarre error, the error is a runtime error 438 'Object
doesnt support this property or method', however, the odity of the error is
that i cannot reproduce this error in the development environement, and it
occurs the first time after a reboot in the live ...

Iam using VB 6.0, Ado 2.6 connect to sql server 7.0 with sp4. When I used
Begin transaction I hit the error Runtime error "2147168227 (8004d01d) " -
Cannot create new transaction because capacity was exceeded
cnConexion.BeginTrans     'HERE hit the error Runtime error "2147168227

How can I find the value of an Identity (autonumbering) column after that a
record has been added to a MS SQL server 2K database table ?
rstQ.addnew
t= rstQ!ID     this doesn't work