database on server

[Kay]

I have an Access 2003 database as a shared file on a server, and the database
is populated by a few people. Normally, several people can open the database
at the same time. It happens quite often, however, that the database may have
not been closed correctly and a small record locking information file of 64k
remains on the server. If that happens, then only one person is able to open
the database. We can't simply delete the small file from the server, nor can
we restart the server (no Admin rights to do that), and also the 'repair
database' function in Access won't help to correct this issue. Is there a way
to repair the database so that several people can get access again?

 

[Gina Whipp]

Kay,

This does not sound like the databse is split... front-end on everyones
local and back-end on the Server... which should vorrect the issues you are
having. So the very first thing I recommend is splitting, see...

http://allenbrowne.com/ser-01.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm