hi all,

i am building applications using VB6 with Access 2K database and ADO, well the access is fine and cheap but it is making me a headache when used by multiusers.

My database code is simple., like the following

'db as connection

VB Code:
  1. db.begintranse

  2. db.execute ("delete * from invoices where code = 13")

  3. db.committranse

now the questions:

1 - is this code problematic when executed by many users on the same dbase file thru a LAN

2 - How could i check to see if anyone is writing to the same table in the same time.

3 - is there a problem in concurrent readings from the same table., = many users are performing select sattements on the same table in the same time.??

4 - Can anyone advise me how to protect my dbase from multiuser corruption , as i am facing now a lot of (Unrecognized database Format) with the access.

5 - i want to make a backup from my access database, should i copy it by using (FILECOPY) or should i make a replica

6 - what will happen if i tried to backup the database while someone is doing anything in.

7 - how could i check that i am the exclusive user on this database

8 - how could i make a replica from an access database with VB6 Code ?


Well i know this is lenghty and hard but i am open to any ideas and willing to share this problems and solutions with other people along with my self


THX in Advance

BST RGDS