VB Forum / Database Access / February 2004

This code work with win2000 and  win98 but don't work under win XP
error -2147467259
why?
Set cnFox = New ADODB.Connection

I have a vb6 app that can access a 2000 access db, and I can change data bases on the fly and the data is update, with out shuting down and restarting the app. I am pretty new to DataEnvironment and DataReport. Now when I first open the app. the last db that it was connected to, ...

I need to add a link to a table in another DB (all are Access DBs) in the
current DB so I can Insert some derived records. I am trying the Sub listed
below but I keep getting an error that it cannot find an installable ISAM
when it gets to the statement to append the linked table. I ...

I've downloaded and installed the latest 8.0 OLEDB drivers for VFP. It's not a problem to make a connection or retrieve the data; however, I cannot update a record. Below is what I'm doing. Any help is extremely welcomed
Private Sub UpdateContactInfo(
   Dim cConnectString As ...

Hi everyone!!
       Please tell me how to view a picture stored in a database in  a picture bor or image control. I want to
      see all the employees' photos just like any other bound field
Thanks a million

I've got an application, and if the user enters data into a bound field and
then closes the form, the dataset is not updated for that last entry.  It
only updates if I move from one record to another.
I can't find a movenext command for the adodc, nor can I find an

I got a recordset where I want to count the number of records with a specific value in a field, how can I do that
Thanks in advance...

Hi I wonder if anyone can tell me if it is possible to manipulate a
dbase file which uses foxpro cdx index files within Visual Basic, or
will I need to use visual foxpro?
TIA

Dear Sir,
I am Using Access-2000, VB6 (SP5), ADO 2.5.
My SQL query is as follows.
SELECT FaPhysicalStockMaster.*, FaItemMaster.* FROM FaPhysicalStockMaster

Is it possible to refresh the path of linked tables using ADO?
I've tried updating the records in MSysObjects but I don't have permission

Thanks,

Our VB6 app uses a frontend/backend database topology (using ADO 2.6).  The
app ships with an Access frontend with all tables linked to tables in an
Access backend.  Users are given the option of switching the backend to SQL
Server.

I am using Visual Basic 6 SP5 and Microsoft Access 2000 (SP3). I am trying to start a transaction, but everytime I get to the cnn.BeginTrans line, I get the error
-2147467259 [Microsoft][ODBC Microsoft Access Driver] Attribute cannot be set yet
The trouble is, there is no rocket ...

Folks
I have a SQL 2000 Stored Procedure that uses xp_aes_encrypt and decrypt to
Insert and return data from a table.
I now wish to call this Stored Procedure from my Vb 6 Client.

Hi
 I designed  form  with 35 text_boxes
I have a table with 40.000  records and  with 35 field
when I save  a new  record it took 3 minutes

iam develpoming a database software with access db and vb front end. while sending the update query to the db it is not working and giving the automation error. iam doing the same procedure from other form but working properly when iam running the same query in access it is ...