VB Forum / Database Access / June 2004

I am makind a database in MS Access and i want to this database to generate
Folders for eaxh new record.
is this possible to do that, or where to ask such  information.

Anybody know the answer, please email me.
I am using Windows XP, I want to use vb6 read the data from Access2000 or Access2002 Database.  The message said it is not recongized datatabase format.
But I was able to connect to Access97 database.   Do I have to install any VB software ...

Simple thing - I want to create an open connection through to a data-source
(in this case an Excel spread sheet) and then do various queries of this
data source using disconnected recordsets.
I determine the connection string which is:

I am using VB data control the old way
Put data control on the form, open a tp.mdb file
GO to recordsource to retrieve talbe name.
It pop up a message, not recongize database format.

Hello, hope someone can help with this.
I have a vb6 application that accesses a access 97 database.  I have a form that has a combo box and datagrid and I use the adodc control (recordset).  Everything works fine when I run the applicatiion but when I compile it and install on a ...

Kan mij iemand vertellen hoe ik in VB een "tabel" kan aanmaken zodat
het mogelijk is om in "runtime" hier gegevens in in te geven. Deze
gevens moet ik kunnen opslaan in bv een willekeurig excel bestand.
Maar ik wil niet dat ik excel moet openen om deze gegevens in te geven

I have a small project that uses Excel 2000 as a front-end for a SQL server
7 database.  The user chooses from a drop-down and the cells of the sheet
are filled.  The user can then change the values in the cells.  When the
user wants to save the data, I want to remove the existing ...

Can anybody answer my question?
I am using Windows XP Professional Edition
Why VB6 can not read Access 2000 or Access XP database file?
VB6 can read only Access 97 file.  I don't know why?  Do I need to install some

I am using VB 6 and Using ADO to connect to SQL. I want to LOCK the
record / table while I already connected to the record / table, is it
possible?
Set cnADODB = New Connection

Hoi,
Cane I add properties to a Jet MDB (Access 2000) or table
collection, and if yes how to do that.
Best regards,

I have export the data to excel.
But in the numeric field which cannot sum up or change format to numeric in
excel.
Why?

I need to read a MF Cobol file (dat/idx) with VB6. It's not a file
convertion.
I would appreciate suggestions.
Thanks

Using an Access 2000 database and linked SQL tables...
Before running a procedure which will replace data in the local Access db
with data from SQL server, I would like to test that a "good" connection
exists betweeen each SQL server table and the Access database.   (I do not

I am getting the same error number in 2 different situations:
Run-Time Error '-2147217873 (80040e2f)':
"Cannot insert the value NULL into column 'SubTotal', table
'Quotes.dbo.Orders'; column does not allow nulls. INSERT fails."

I wrote a tool that will update records on an Oracle 8i db. The problem is
is that I designed it to update only one record per employee.  Now it looks
like employees can have more than one record.  So, I would like to snag the
primary key when the search is done on the employee ...