Compact and repair with windows xp problem

[Guest]

i have an acess 2000 database residng on a windows xp
machine. if i compact and repair the database with the xp
machine, on all the windows 98 workstations i get locked
out of the databse with this error message "The Microsoft
Jet database engine cannot open the file 'path to file'.
It is already opened exclusively by another user, or you
need permission to view its data." if i move the databse
to a win98 machine and compact and repair, and move it
back to the xp machine, it works fine? HELP

 

[Wayne Morgan]

To compact the database it needs to be opened exclusively by only the person
doing the compact, all other users should be disconnected (first) while the
compact is going on. When the person who compacted the database is done and
closes Access, the ldb file should be deleted. Check in the directory that
contains the mdb file and see if the ldb file is still there after Access is
closed. If it is, do you have delete permissions on that directory?