Hi,
I have a multiuser database which creates a daily log in a word file. If the log file is already open a problem occurs as the db does not have exclusive access to it. Can I force a file to close if it has been opened by another user ? On another note does access have an option to only allow one copy of the database to be open ? I could implement this with a lock field in a table, but it is easy to get locked out if the db crashes.
Thanks
Mordja