VB Forum / Database Access / May 2004

I have a query in Microsoft Access that uses a function. When I call this query from VB, I get an error message that the function is undefined. I can run query in Access with no problem and see the resultset
Any suggestion
Thanks in advanc
Ray

I'm a beginner of ado.net.
Can anybody help me for the two problems as follows:
How to import data from Excel to datatable
and export datatable as Excel file.

Hi group.
I have a Recordset (rs) with a Field named "Id", so I set
rs.Sort = "Id ASC"
Here is the issue: the compare method (used do sort) seems to ignore

Sory my english
i have a ado recordset
ado_familiar.recordsource="Select * from familiar inner join empregados1 on
familiar.empregadosID=Empregados.ID

I'm populating a MSHFlexgrid via ADO within VB6, and have never had any trouble. But now I'm querying quite a big table and get different results from within SQL Server and VB6. My query is correct, but when executed in VB6 I only get a portion of the result. When I do it in SQL ...

Hi Guys, i hope someone can help me here,
I am using ADO to read a text file (csv) into a recordset, and i have
popluated my form and added facilities to move between the records.
However, if the data on the form is changes, i want to uypdate the

I have a database called Postcode that contains two columns - Postcode
and Building. I am trying to use the txtpostcode ( Number) to search the
database and return the results (Building)to txtzone.
I am using the following code without success can any one assist -

How do you connect to an Access Database when it is located on another server?

With DAO I used following when creating a database:
   Set MyDatabase = DBEngine.CreateDatabase("C:\MyDatabase.mdb",
dbLangSwedFin)
Now, how do I set the locale (dbLangSwedFin) with ADO? I have found out

I wonder is someone could help me. We have an Access DB which has a field
type we need to chnage programatically.
Does anyone know if this can be done, offer some sample code snippit ?
Cheers

I am accessing the DataBase (Access) from my VB program.
I created a Frame that has a DAODB control with the Wizard.
I can view the first record.
Now I want to "Seek" to a record.

I have a stored proc on my SQL 2000 that looks something like
..
UPDATE ... SET ..
..

I have VB 6 application and I am using the WISE Installer 9 to package it.
I receive the following error when compiling the WISE script:
You cannot place the installation executable into itself.
The line in the script is:

I'm working on designing a VB 6.0 / SQL Server 2000 application.
Here's what I would like to do...
The user typically spends most of his/her time in a data entry form
that displays 50,000+ records.  The system is operating via a wireless

Newbie here.
I need to update a single field in a row, 250000 rows, predicated on data in
an existing field in the row.
row.field(1) has value, then row.field(2) now has this value.