VB Forum / Database Access / April 2005

i have an existing vb6 dao application that needs to be converted to ado.
the dao version is as follows.
   Dim N As Integer
   Dim theDatabase As Database

I have a VB program (say on machine A) who connects to an
Access 97 database using ADO. This Access db is located
on another machine (say machine B). When machine B (where
the Access db is located) is rebooted, I open the ADO

When I iterate through a column collection I get the columns in alphabetical
order.  Is there any way to obtain them in the order they were created (which
is also the way they show up in the design mode of Access?
Peter Schoots

Using vb.net, how can I get default field values into textbox values when a
new record is initiated?
Jim Evans.

Can anyone provide me some examples of using a Heirchal recordset such as
Customers - Orders - Order Details in the Northwind database without
employing the use of the Shape construct. Any help would be much
appreciated. Thanks

I have several dBASE 3 tables
in access i can have a union query that makes 1 table of these several
tables
the problem is i need to have this 1 table in dBase 3 format

i have a database (access database/table) that lists the forms in my
project. it is stored as string/text and i want to SHOW that particular
form. how can i do it? I am using Visual Basic 6 SP6.
it just like

VB.NET Web Programmer in New York $40/hr
We are looking for someone to work as a VB.NET Web Developer. In this
role, you will design and develop application software for a successful
global corporation. You will also support and install software

How can I get a 3021 error on a Access table when I'm inserting records into
a table that has a autonumber field as it's sole key? Any ideas?
BTW: I get this error no matter if I use ADO or DAO methods. The strangest
thing is that it just suddenly started happening with 5 out of 7 ...

I have code that executes a SQL query against an Access table and then
tries to use the result to build another query.  Problem is: to make
the new query I need to save some of the recordset field values as
strings, and I'm getting an "Object Required" error.  Here's a snippet:

My VB 6 application accesses data from an Access 2000 database via DAO.  I
create a tabledef object and loop through the fields in the tabledef.  I am
experiencing problems on a user's system where trying to create a tabledef
object causes my application to crash.  I am unable to ...

I have 2 connections to 2 databases (db1, db2)
The connections are fine.  But when I tried to do the following statement, I
got an error:
Public db1Conn As ADODB.Connection

Hi, newbee question.
What software would be best for the following situation?
Web enabled database with an SQL back-end over a Windows based intranet
network system.

I am new to ADO and converting an existing code from DAO to ADO.  I stumbled
into a problem where a table would not append to a catalog object.  I think I
figured out why but it does not make much sense.  Can anyone explain the
behaviour below?

The error message that I'm getting is RunSql action requires an argument
consisting of an SQL statement. Here is my code; what I'm referencing to is
this specific line of code:
JobTitle = "SELECT ([First Name]) From [Days Avaliable]"