Handling Records In A Multi-user Environment

[sonper]

Hi guys!

I like to know what is the most effective way of handling records on a multi-user environment (connecting to db, adding, deleting, editing records). There are records in my database that does not have a valid bookmark. Does it in anyway connected to the way I add, delete, edit and update records?

Thanks.

 

[Michael42]

sonper,

Could you elaborate on:
1. How you connect (DAO, ADO-to-Access, ADO-to-Oracle etc.)?
2. Are you using Data Controls?
3. What version of VB (5,6)?
4. Project maximum users that may edit a record at same time.
5. Max users that may connect\use app at same time.

Thanks,

Michael42