biodtl
10-29-1999, 05:24 PM
I have a VB6.0 program that pulls data from an Access database and inserts it into a sql database. Previously when using Access97 format, it worked fine. But now that were getting Access2000 DBs, we had to change the DAO component we were using from 3.51 to 3.6 to be compatible with Ac2000. Now that we've done this, we cannot insert into our sql database. We can read from sql, but not write to it. Anyone have any suggestions?