VB Forum / Database Access / February 2004

Is there an efficient way to know if table has been changed (e.g. recoreds been added) before adding a record in ADO.net. Doing Fill  before adding a record is not efficient I am looking for stored procedure and quickly tell me if recorded has been changed and maybe then I would ...

I have a User side static recordset. Sometime when I use
recordset.delete and then recordset.requery to delete current record,
the recordset.state will changed from 1 to 0. But this situation does
not happen all the time. What is the possible reason causing this? I

VB6, ADO, Oracle 8i
I currently update the database from my form and I send all the information
from the form to the db when the end user clicks on "update".  I now want
the prgram to be smart enough to update the database with only the fields on

I 'm opening a ADO recordset from a foxpro free table from vb (below is
the code). Things work fine for me. When tested in a machine where VFP 7
is installed it throws an error like this
"[Microsoft][ODBC Driver Manager] Driver does not support this function"

We are exchaging files with our partners and for that purpose I want to create a XML document dynamically using the data present in the database using VB. Please help..
Also when the file comes back from our partner I want to read the data back from the XML to SQL server using VB.

How do I resolve this problem.  I have found "WorkArounds2=24" but don't know where to add it or even if this is trully the solution. Please help!  

I'm trying to set up an application to read data from an Access database
First I include the ADO component
Then I initialize the connection string.  (I use Jet 4.0
And I choose the Table record source

when I create  a setup.exe  using  Deployment wizard  , I copy all the cab files into a CD
the user can run the setup wizard (setup.exe) from the CD   but  the user needs to copy the database.mdb  from the CD into the  C:\drive  
how I can add my database  into the deployment ...

Hi all i am writing a program to validate shipping container numbers.
Basically it gets each letter and number, gives it a value, does a bit of
math and spits out an answer (kinda like basic cd key validation). I
currently have 7 text boxes (one for each character). Everything works ...

I have been reading a good ADO book in which the author indicates different
methods and properties available for asynchronous connections. I understand
the term, but in the book the author doesn't speak to the relative benefits
of one verses the other or the conditions that would ...

Hi Group,
I want to use ADOX to create a new Access database with a table.  Then I
want to put some rows in the table, do something with the rows to get a
result and delete the database file.  I don't see a close method in the ADOX

Hope someone has run into this before and can help me out.
My software uses vb6 and ado to connect to both access and sql server
databases. Recently, some of our
customers running windows xp pro have started getting and error trying to

A friend asked me how to use a progress bar to show progress while a query
is being executed via ADO.
I don't really know unless there are some events that are trapable for the
command object.

Hello
I have installed Win 2000 with SP4. Then I instaled Map&Guide. By
statting M&G  i get the error Message " Databse could not be opened,
ADO 2.1 or higer is needed" Then i instaled MDAC 2.8. succesfully but

I currently have to deal with the following problem and hope to get some
help by describing it in this newsgroup.
I'm writting a multithreaded application, were one thread stores new
information in a MS Jet database using the ADO interface. Then another