VB Forum / Database Access / January 2004

I'm using MSHFlexGrid, I want populate the grid with the records of a
database.
strConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" & App.Path
& "\db\arch_costi.mdb"

Morning Group,
Can someone possible answer a simple question for me?
Should I use the Database Connection, DataAdapter, and Dataset Wizard or
should I right my own code and not bother with the Wizards?

Is it possible to run a project with a database connection
just from the executable file?  If so, where does the
database file need to be located?

Hello and happy New Year.
With:
  VB 6.0 SP5
  ADO 2.7

we are working with VB 6 and ADO using SHAPE to recover data from database:
   Set rsProductos = New ADODB.Recordset
   rsProductos.CursorLocation = adUseClient
   rsProductos.Open strQuery, strConexion, adOpenStatic, adLockReadOnly

hi i have the below code that connects to an oracle database
what i want it to do is the user selects the date required on a
calender object  types in a number in the a text box and press a
button it then should the carry out the query

Group,
I'm working with a project group supporting and enhancing a product that has been around since the earliest days of Visual Basic.  When moving to a new version, it was a matter of them updating the necessary code
Before ADO was even conceptualized, this group utilized the DB ...

Group,
I've got a VB6 frontend to an Access 2000 database.  I'm using DAO
recordsets to populate 2 DBgrid's.  The DBgrid's are populated
correctly on my Windows XP production machine and 2 windows 2000

I have several apps that we have developed using ADO and MSDASQL. They connect to our SQL database just fine from Windows 2000 development machine or a Windows 2000 machine we are installing the MSI to. When I bring them up on my XP Pro development maching I get the following ...

I' m using Vb 6.0 And Access 2000
Can i write some expression in Access database after creating by using vb6.0
For example
in the database have 3 Column

I am using ms-access and in that I link
the tables from oracle. I create
a form and in that i have a text field e.g. emp_no
this emp_no field should take the max value from

1) Do the posts in this forum also appear on the USNET newgroup feeds
2) What is the NNTP Server or IP Address for the microsoft newsgroups that can be use in a reader like Free Agent?

I'm trying to create a VB applciation. When i try to run this query with an
access database:
"select * from order where orderDate = #" & date() & "#"
the query return the information requested.

In my application the program goes through all the database stages for each
transaction.  I am using DAO 3.51.
For example in getting a recordset, program does this:
OpenDatabase

I am using VB6 (SP5) and a SQL 2000 recordset
One of the problems i am having is the moving from one
record to another. In one Recordset there are 300
records, when i hit record 300 i would expect the EOF to