VB Forum / Database Access / April 2004

what is the alternative to the old DOS commad (dir/s)?
in visual basic?
thank you.

I'm currently in the planning stages of my final project at
university. I have decided to make a business simulation game using
VB6. I am a beginnner with VB so am after some advice on the best way
of going about implementing a database into the program.

I'm currently in the planning stages of my final project at
university. I have decided to make a business simulation game using
VB6. I am a beginnner with VB so am after some advice on the best way
of going about implementing a database into the program.

In my VB program using Access database, I want to get only records that
match my query criteria (i.e. memberID *AND* dateBorrowed in the table
tblItemBorrowed). MemberID is an integer, dateBorrowed is of Date type. To
view a list of all items borrowed by a member today,  I used the ...

I am having a problem inserting new records via VB into an SQL server
table that has its id Field set as an Identity.
it appears ADO does not let the fiels increment when updating inserting
the new record as i keep getting a primary key violation error  "cant be

The line
Set f = ado.Recordset.Fields("id")
where f is a Field and ado is an ADODC control, it says the field cannot be
found.

I have a class module set up called Quiz
I have a access database with two tables Quiz and Identification
I need to be able to determine the amount of records in the Quiz table to
generate a random question. The problem is I cant seem to get the code to

Dear , all
   How can i create ODBC from VB 6 . the ODBC connect SQL SERVER
Thank,

I've been trying relentless to import a text file into an
access table using visual basic, but with no luck. Does
anyone has codes for that purpose?

I want to compact my Jet 4 database using ADO. As I may not know the
location of the database on my clients machine, I have set up a DSN called
NEQAS that points to the database on my clients server.
I am now a little lost as to the next step I must perform to compact the

I'm looking at some code that makes use of OpenRecordset as follows:
sqlOnBatchQuery = "SELECT * FROM PRODUCTBATCHES WHERE BatchNo = '" &
cboOnBatch.Text & "'"
Set rstOnBatchProductBatches = dbKCRetail.OpenRecordset(sqlOnBatchQuery,

I'm a student Informatica in Belgium. We get classes Visual Basic here and
where now bussy with the subject databases.
I work on my laptop where i've installed an Win XP OS with an Office 2000.
The problem now is that i'm not abble to connect to my access database. I

I'm a student Informatica in Belgium. We get classes Visual Basic here and
where now bussy with the subject databases.
I work on my laptop where i've installed an Win XP OS with an Office 2000.
The problem now is that i'm not abble to connect to my access database. I

Where can i find an example. Is there a FAQ site off this group?

the vb code is looping through a recordset
within the loop another stored procedur
with ado is appending parameters and then executing
the first excute within the loop works