SQL Database Application

[Rhys_SSD]

One other point I forgot to raise in the last post.

There was previous mention of handling multiple user requiring access to the same table.

As a general rule, how is this handled in database applications?

Can multiple users access same tables concurrently?

What happens when users attempt to access the same record in a table?

Should I program something to avoid this?

Maybe an identical column in each table which shows the edit/in access status of each record?

Rhys

[SimonAldred]

With our systems there are multiple users trying to access the same tables. I am not aware of any problems thus far.

[aputman]

---

@Rhys_SSD wrote:

Should I program something to avoid this?

Maybe an identical column in each table which shows the edit/in access status of each record?

---

This is not necessary as the database will handle this for you.  However, you may want to consider using transactions in your stored procedures, especially if they are long, complicated procedures that do a lot of data manipulation.  If a transaction fails for some reason, it will rollback all changes made since the transaction was started and throw up an error.  If you are only doing simple inserts into a table and selecting data from a table, transactions are probably overkill, IMHO.