Hi everyone.
I have 2 problems :

Problem1.
I have created a VB6 front-end that will reside in a shared network drive.
It will copy an Access database from another network drive to the application
drive and then retrieve data and paste it into a Word file. The application
is to be used by many people. When I tried to (almost) simultaneously run the
program from 3 workstations I got error messages like 'Permission denied' and
'Path not found' (the database is easily accessible), yet a short time later
the Word files came out correctly! What might the problem be? I then tried
inserting 'On Error Resume Next' and there were no error messages.

Problem 2.
I have also written another VB6 front-end thet will reside on a network
drive and will be accessed on many workstations in order to book particular
rooms. The application connects to an Access database (on the same drive as
the app) so the when a user runs it, it checks to see who is currently
viewing a particular room (this information is recorded by the program). When
I ran the program again (almost) simultaneously from the 3 workstations, each
opened and when I 'reserved'  a room on one machine, I waited a few seconds
and attempted to view the same room on another machine but I did not get any
warning that the room was already 'reserved'. Was Access not updating the
table that records who is reserving a room? I have been advised to consider
SQL 2000 as it it a much better networking back-end and can handle concurrent
record access more effectively.
What do people think?

Thanks in advance
Tim