I imported dbf files (dbase) into an msde database.
I see the tables with the data in the msde database. The data is identical.
The only change made to the code is in the DSN assignment in the Recordset's
Both DSN's are ODBC, the original uses Microsoft dBase driver (dbf),
the msde is of course SQL Server.
Using the SAME data and the SAME code I add a record (AddNew())
the Recordset.Open() takes about 4 or 5 times longer with the msde dsn
the Recordset.Update() takes about 10 times longer (eg. 10 seconds with the
msde dsn, less than 1 with dbase odbc dsn)
Are there changes that have to be made in the code or in the data?