Modify dBase Files with DAO

Modify dBase Files with DAO

Post by vanni » Fri, 09 Mar 2001 03:59:10



Hi! I'm trying to make inserts, deletes and updates to a dbase file with
Vbasic... I've tried with ADO, but an error message is shown when I do  
deletes...  
somebody toll me that DAO is the best way to do that, but I dont know how to
use it... does anybody have a little sample code about it?
Thanks in advance!
Vannia
 
 
 

Modify dBase Files with DAO

Post by Steven Bra » Sun, 11 Mar 2001 01:27:51


Using older versions of the ODBC driver for dBase, you can only read, not
write to the file.

Suggestions:
1. Try using the Microsoft Visual FoxPro driver instead; this should permit
read/write access in either ADO or DAO.
2. Upgrade to Microsoft Data Access Components 2.5, sp1, found at
www.microsoft.com/data. This version of the dBase driver SHOULD permit
read/write access. Remember, though, for either ADO or DAO you MUST have a
unique primary key on the table in order for ADO or DAO to permit writes to
the file.

Hope this helps!


Hi! I'm trying to make inserts, deletes and updates to a dbase file with
Vbasic... I've tried with ADO, but an error message is shown when I do
deletes...
somebody toll me that DAO is the best way to do that, but I dont know how
to
use it... does anybody have a little sample code about it?
Thanks in advance!
Vannia

 
 
 

1. Using dbase MDX Files in VB Apps w/DAO

Hi All:

        Can anyone send me a snippet of code showing how to use a structural MDX
file (with its associated DBF, of course!) in Visual Basic?

        I am able to open the Database and recordset using DAO, but I am a bit
unclear how to select the multiple tags in the MDX file (the manual does
not show any good examples, per say).

        Any help here would be greatly appreciated!

All the best,

Kevin

2. Paradox 3.5 - Record size calculation?

3. Connect dBase Files With DAO

4. SQL QUERY

5. Openning an dBASE III file type with DAO

6. NT Oracle7.2 - dates problem

7. Read/Write problems with DAO and DBase file

8. Cursor library issues

9. DAO Blob Adding/Extracting (audio files, text files, image files, program files)

10. DBASE III- having problems reading dBASE files to VB

11. Converting dbase IV files to dbase 3+

12. Exporting dBASE IV memo field to ASCII file without using dbase IV

13. Dbase 5 files and Dbase memo field problems