VB Forum / Database Access / August 2005

I would very much like some help with this if anyone has a moment.
Michael
=========================================
Help!

(This is a reproduction of a post that I made in the Office VBA forum, but I
also tried this in VB6 and received the same error.  Somehow Office 2003 has
blocked me from connecting to Excel via ADO).
Hello,

Suppose I have 100 table with a field 'name'
I want to SELECT the values of this field from all POSSIBLE tables that
may have it..
Can I do from SQL?

Can I have my data from a SELECT query passed to a tab text, an xl file
or sth else with only using the SQL language?

I can not connect the MS Access database mdb using VB 6.0 code as following,
Dim myDB As ADODB.Connection
Set myDB = New ADODB.Connection
strConnText = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

Hi, I'm having trouble writing to a newly created table and field in an
Access database.
I successfully create a new table "Revision" and a field  "Rev_Level" with :
------

building a patient reminder system with MS access 2000 on backend.  need
correct syntax for following problems. OK, so here goes...
2 tables: PATIENTS AND SCHEDULED
-Patient is recalled on a specific date called RECALLDUEDATE

Two posts below mentioned something about "WatchDog Timer".
Would you guys tell me What/When/How is a "WatchDog Timer" please?
Thanks!

Does anyone have some sample code on how to create a renamed duplicate
database on the same SQL server instance?
Basically I have a template database that will need to make copies so I need
to copy and rename the database.  I tried the detach rename reattach method

Within as ASP page, I have the following line of code:
   sData = rsForcedExport.GetString(, , "|", vbCrLf, "")
This gives the following error message when running on a live web site, but
NOT when running in the DEV environment:

I was hoping someone could help me. I have been asked to look at creating a
simple CRM system for our salesmen. We wish to export records from out main
database, which is a DB2 database located on an AS/400. These records will
be imported into a database located on an MsSQL ...

rs.addnew will assign an autonumber for you.
Is there a way to know what the next autonumber to be assigned will be
before the rs.addnew by using a command instead of something like
rs.movelast

I have a program that has been running fine.  However, ever since I upgraded
to XP, it has been giving me problem.
I have a ODBC data source pointed to a Access MDB file.  When I try to
Insert/Update a record, it will say "Error In Row".

Visual Studio .Net  2003 /  VB .Net
Database:  Informix SE,  SQL Server 2000  or Linux
I am in the process of migrating our MS Access Database to Informix Dynamic
Server.  My test database is on a Linux box (Informix Dynamic server is not

MS access 2000 db on backend
working in VB6
trying to open this recordset
i have 2 dates