Multiple users accssing a database

Hi, I'm developing an questionnaire application that will hopefully be filled in by all pupils at the school I work at, and will run across the school network.

The questions and answers are read out of and written back to an Access 2000 database which resides on a drive that's invisible to the user, but the application can see. It all works perfectly for the first user on, but all other users get a "file already in use" message when they try to log on.

Is there any way to let multiple instances of the same VB application access the same database, at the same time? There's no issue with concurrency, the way it's been designed means that every pupil has their own record and only reads and writes to and from their own record.

I've spent far too long on this now to give up, I'd really appreciate any suggestions?!

Thanks!!!

Gavin Craddock

Are you using Bound forms in VB when connecting to the Access DB?

S-