Error "Your computer is out of disk space..."

[jsteph]

Hi all,
I get the error:
"Your computer is out of disk space, you won't be able to undo this paste append, do you want to continue anyway?"

...When running vba code which does a transfer-text, Access 2003 on Win Server 2003-64 bit.

I've googled this and seem to come up with only sites listing Access errors and their #'s, this one is 10017.

Anyway, the computer is not out of disk space, there are many gigs left on both the System (C drive (where the jet temp files would be) and on the raid set where the Access .mdb is on. The .mdb is not anywhere near the 2-gig max, nor would it be once the file is imported.

Does anyone know what this may be? I click ok and everything *seems* ok, but I haven't looked record by record of all the imported data to make sure it's all intact.

I'm wondering if it has anything to do with the 64-bitness of the OS, maybe Access has issues with that? I've upgraded to whatever the latest Office 2003 service pack is (11.8166.8172 SP3), and the os is server 2003 x64 SP2.
Thanks for any help,
--Jim

 

[lameid]

This sounds to me like you have exceded the Maximum file locks. If memory serves it is a registry setting called MaxLocksPerFile.

If my memory and registry digging are right...

Increase the MaxLocksPerFile registry key found under

\\HKEY_Local_machine\Software\Microsoft\JEt\4.0\Engines\Jet 4.0\

It has been a long time since I hit a similar error. Hope this helps. My default key value is 9500 in decimal. If I am right, it will either take longer to hit the error or you will not get the error if you increase this value. I don't think you have to restart the computer but I believe you do have to close and reopen Access. Obviously, if it takes longer but you still get the error, you need to make the value bigger.