VB5 - Access 97 - SqlServer 6.5 - non-disappearing tmp file
Quote:
> I am updating tables in an SQLServer 6.5 database via linked tables in
> an Access 97 database by ODBC from within VB 5.0. My problem is that
> under heavy use the JETnnn.tmp temporary file grows to huge proportions
> (100Mb+) and does not disappear on transaction commit or database close.
> It finally goes on closure of the application.
> Is this a known problem and is there a workaround? My only idea is to
> spawn each heavy transaction (1000+ updates) as as separate self closing
> application but this seems to be a very wasteful way of doing it.
> David Early.
Try resetting the database engine with Set DBEngine = Nothing.
This might accomplish the same thing without having to close
your app.
--
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!
