I'm developing a VB4 application that uses an Access 2.0 database
This database is currently 250Mb (yes 250mb!!) and I'm using several
insert records in some tables.
If I use a Recordset object and use the AppendNew Method to insert records
a small table everything is fine. But, if I do this same thing on a large
the process is perpetous. I worked around this problem by using the
Execute Method on the Database object using an Insert statement. The code
is something like this:
dim mydb as database
dim s$ as string
' Here I create the string s$
s$= "insert into table1 values (1,23,4.5667)"
mydb.Execute s$ dbFailOnError
This worked right for some time but now everytime this code executes I get
3343 Unrecognized database format: "c:\databases\mydata.mdb"
After this the database is wrecked and I must repair it. This takes up to