[AccessD] Compact/Repair doesn't work in XP when file on the network

Stuart McLachlan stuart at lexacorp.com.pg
Tue Apr 1 16:55:29 CST 2003


> Recently upgraded to Windows XP and Office XP.  MDB files now will not
> compact and repair when they are located on the network.  Error message
> says the file is already in use even if the file is not open by any
> other users at the time.  This message happens in Access XP 2000 file
> format and Access XP 2002 file format.  It does not happen when the file
> is on the C drive.  I have not been able to recreate this in an adp
> file.  Making things a bit more confusing, occassionally, files do
> compact and repair even on the network.  Haven't found any similarities
> with this.  Anybody had experience with this or know anything?  Can't
> find anything about it in KB.
> 

I've come across occasional problems with  Win XP workstations on networks and 
various applications, I've heard numerous accounts of others with similar problems.

They all seem to revolve around either periodically losing the network connection or, 
more commonly, not releasiong locks on files. I've very rarely seem anyone come up 
with a fix other than reverting to W2K on the workstation :-(

 (maybe that's why W2K still costs more than WinXP <g>)

Personally, I'm staying away from XP as long as possible 


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.





More information about the AccessD mailing list