VB Forum / Database Access / April 2006

Having problems finding a duplicate record from a access database using
ADO control.
Actually I am using ADODC control in VB 6.0 with a Student database
(access database) where Studentname being primary key and student

I have a ASP.Net application that uses a MS Access database. The site works
fine when all databases resides locally but on my public server I need to use
a different database where the main databasefile resides locally but also has
tables linked that resides on a ...

I'm new at this.  Here's what I'm experimenting with.
(Win 2K Pro SP4, ADO connection to Access 2K .mdb, MDAC 2.8, Jet 4.0 SP8)
I have a main form with a set of Textbox controls linked to tblCustomers and
2 DataGrid controls, DGOrders linked to tblOrders and DGOrderDetails linked

I am in the process of learnign VB.Net 2005 after programming VB 6 for the
last several years. I have been trying to find a way to create an ACCESS
database programmatically but have had no luck, from MS documentation or
Google.

I get this error after selecting a database file and click the 'next'
button.  Anyone know why - it is an Access .mdb - tried it with several of
them.  This is in a new Data Project.

 Im trying to search a field on my database, i use this code:
  If txtFiltro <> "" Then
        Datos.Recordset.Filter = "empresa LIKE '*" + txtFiltro + "*'"
     Else

Is there a method available to copy an entire table to a new table name?

Hello all, I've successfully compiled a source written in VB6 - Sp6
wich connects to Access 2003.
The operating system is WinXP-sp2.
The software works well when run from the Visual studio ide ("run with

I would like my app to have its own run-time data connection wizard so that
users can connect to a data source of their choice. I'm new to ADO.NET,
previously programing for RDO/ODBC. With that, I could actually invoke the
Data Source wizard from the Windows System, ...

Using ADO in VB6 the following SQL clause creates an error that reads as
follows:
[Microsoft][ODBC Visual FoxPro Driver]Data type mismatch.
the sql statement is:

What is the proper code to use for a stement like the following:
Insert into Input1ph Select * from Custom1ph where Quote = '169163.001'
Where Input1ph is in an Access MDB database and Custom1ph is a Foxpro DBF
table. Or can this even be done simply?

Whe have a classic ASP/VB application and we need to make sure that
connection pooling is being used properly. What would be the best way to do
that?
Thank you,

I am unable to drop a sql server database that I created in my application.  
I am
listing the following steps that I took in order to delete the database.
1)     Connect to SQL Server

Hi all,
After a program instalation (I don't know exactly which one!), my VB6
projects cannot access ADO anymore. It return "Automation error" when I run
my program. Ok, this is a MDAC issue, so I instaled it again. But...

------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://www.codecomments.com/message891775.html
------------------------------------------------------------------------