# SQLite SQLDatabaseMBS multi-user

**URL:** <https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061>\
**Category:** Databases\
**Created:** [June 22, 2015, 8:42am UTC](https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061 "2015-06-22T08:42:45Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Cox](https://forum.xojo.com/user_avatar/forum.xojo.com/david_cox/32/227_2.png) [@David\_Cox](https://forum.xojo.com/u/David_Cox)\
**Post date:** [June 22, 2015, 8:42am UTC](https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061/1 "2015-06-22T08:42:45Z")

</div>

I know how to set up a Xojo SQLiteDatabase as multi-user (db.MultiUser = True), but how do you set up an SQLDatabaseMBS database as multi-user?

---

<div class="post-metadata">

**Author:** ![Christian\_Schmitz](https://forum.xojo.com/user_avatar/forum.xojo.com/christian_schmitz/32/158_2.png) [@Christian\_Schmitz](https://forum.xojo.com/u/Christian_Schmitz)\
**Post date:** [June 22, 2015, 9:28am UTC](https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061/2 "2015-06-22T09:28:51Z")

</div>

multi user? with SQLite?

---

<div class="post-metadata">

**Author:** ![Christian\_Schmitz](https://forum.xojo.com/user_avatar/forum.xojo.com/christian_schmitz/32/158_2.png) [@Christian\_Schmitz](https://forum.xojo.com/u/Christian_Schmitz)\
**Post date:** [June 22, 2015, 9:30am UTC](https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061/3 "2015-06-22T09:30:50Z")

</div>

SQLexecute “PRAGMA journal\_mode=WAL;” and you changed to WAL mode.

---

<div class="post-metadata">

**Author:** ![David\_Cox](https://forum.xojo.com/user_avatar/forum.xojo.com/david_cox/32/227_2.png) [@David\_Cox](https://forum.xojo.com/u/David_Cox)\
**Post date:** [June 22, 2015, 10:13am UTC](https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061/4 "2015-06-22T10:13:44Z")

</div>

Thank you. I often have two or more apps (e.g. one main, plus a ReportWriter and a Scheduler app) accessing the one SQLite database.

---

<div class="post-metadata">

**Author:** ![Christian\_Schmitz](https://forum.xojo.com/user_avatar/forum.xojo.com/christian_schmitz/32/158_2.png) [@Christian\_Schmitz](https://forum.xojo.com/u/Christian_Schmitz)\
**Post date:** [June 22, 2015, 10:31am UTC](https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061/5 "2015-06-22T10:31:12Z")

</div>

Welcome

---

<div class="post-metadata">

**Author:** ![Richard\_Duke](https://forum.xojo.com/user_avatar/forum.xojo.com/richard_duke/32/246_2.png) [@Richard\_Duke](https://forum.xojo.com/u/Richard_Duke)\
**Post date:** [June 22, 2015, 3:20pm UTC](https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061/6 "2015-06-22T15:20:00Z")

</div>

David, I assume what you mean by multi-user is not really many user/machine using one database but one database use by multi program access on one machine.

---

<div class="post-metadata">

**Author:** ![David\_Cox](https://forum.xojo.com/user_avatar/forum.xojo.com/david_cox/32/227_2.png) [@David\_Cox](https://forum.xojo.com/u/David_Cox)\
**Post date:** [June 22, 2015, 3:28pm UTC](https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061/7 "2015-06-22T15:28:32Z")

</div>

I have two WebApps and one Console app accessing the one SQLite database at the same time. It is not shared on a network server or anything dodgy like that. Multiple users can connect into the WebApp at once. The SQLite database is opened once at startup then each Session creates their own recordSets from that one app.db database. Their usage is light as it mainly holds connection settings data through to a series of Postgres databases.

So it is multi-user in that three Xojo applications are accessing the one SQLite database at the one time.

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [October 29, 2020, 5:48pm UTC](https://forum.xojo.com/t/sqlite-sqldatabasembs-multi-user/25061/8 "2020-10-29T17:48:57Z")

</div>


