T
Terry
I am working with some large tables and am being
good and spreading the tables across several databases
that I then link to in the database I am actually
working in. the working database is actually pretty
small, mostly being VB code, about 100K or so.
The problem is that when I do some queries across some
of these big tables, the size of the working database
blows up above the 2 gig limit (presumably due to some
intermediate results)and I start getting error messages
like 'that operation not supported'....
I have rebuilt the working database a couple of times,
and am getting database files that are >2Gig that
I can't get rid of....tried everything I can think
of from using DOS (which says access is denied). if I do
a 'calcs' on the directory, I get 'access is denied'
for that file. If I try to delete it in windows, it
says the file is in use or locked. there is no lock (ldb)
file for the ones I am trying to delete. the owner is
shown as a blank; the others are administrators; I have
admin privs on the machine.
So, long winded problem statement; the biggest problem
at the moment is how to get rid of those 2 gig files?
thanks for any suggestions!
Terry
good and spreading the tables across several databases
that I then link to in the database I am actually
working in. the working database is actually pretty
small, mostly being VB code, about 100K or so.
The problem is that when I do some queries across some
of these big tables, the size of the working database
blows up above the 2 gig limit (presumably due to some
intermediate results)and I start getting error messages
like 'that operation not supported'....
I have rebuilt the working database a couple of times,
and am getting database files that are >2Gig that
I can't get rid of....tried everything I can think
of from using DOS (which says access is denied). if I do
a 'calcs' on the directory, I get 'access is denied'
for that file. If I try to delete it in windows, it
says the file is in use or locked. there is no lock (ldb)
file for the ones I am trying to delete. the owner is
shown as a blank; the others are administrators; I have
admin privs on the machine.
So, long winded problem statement; the biggest problem
at the moment is how to get rid of those 2 gig files?
thanks for any suggestions!
Terry