Questions to multi user scenarios

[juvi]

Hello,

I have got a database on server (backend) where frontend-dbs can write data
through adodb connection and adoConn.execute strSQL. The backend-db has also
a form-based application.

I have got two questions to multi user scenarios:

(1) how to prevent exclusive write event from frontend-dbs and implement
multi user write possibilities to backend-db?? is this possible?

(2) how to let the backend-db be usable during write-progress of
front-end-dbs?

thx
juvi

 

[Rick Brandt]

Hello,

I have got a database on server (backend) where frontend-dbs can
write data through adodb connection and adoConn.execute strSQL. The
backend-db has also a form-based application.

I have got two questions to multi user scenarios:

(1) how to prevent exclusive write event from frontend-dbs and
implement multi user write possibilities to backend-db?? is this
possible?

(2) how to let the backend-db be usable during write-progress of
front-end-dbs?

Both should automatically be true by default though the second is a
questionable thing to be doing.