--- In [email protected], "brucexs" <bswit...@...> wrote:
>
>
> > Class myrecord has -3 objects unfreed
>
> So it has done 3 too many frees. How many records in your database?
>
> If you want to do some checking around, I would just make
> myviewstruct global and insert myviewstruct.check before each
> quit statement.
Even without doing that I can tell it is related to the number of records. The
one reporting -3 had 4 records; another reporting -2 has 3 records.
> > The drivers for ADO and Jet are part of XP, not an optional part
> > of Excel. You might have had some other issue. Try restarting
> > Powerpro and running it with Excel not running or at least the
> > xls file not elsewhere open.
>
> Error is
>
> com.methd:" Invoke failed
> error 80004005
> from microsoft jet database engine
> could not find installable isam
>
> I take that to make that some dll/object that provides isam
> access method to excel is not on my system.
That's not the only possibility per msdn. I still suspect the connection
string. Maybe some extra or missing spaces thanks to Yahoo broken lines.
Change it to this:
mydb.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data\x20Source="++strdb++";Extended\x20Properties=Excel\x208.0")
There are no spaces in above (except as will result in PP from \x20).
Regards,
Sheri
