• Registered: 2014-03-18
  • Posts: 2

Topic: Multiple Users

I created a very nice DB but realized that if i put it into production i will have multiple users attempting to access it.  Is this possible?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Multiple Users

This is possible if the users on the LAN.

Place file "sqlite.db" in share folder and setup setting: Options > Database location

Dmitry.
  • Registered: 2014-03-18
  • Posts: 2

Re: Multiple Users

thank you, I did not think of that.

I have played with LibreOffice and it became more difficult to split the DB.

Is there a way to load legacy data into the DB without manually entering each record through the form? 
I got spoiled with LibreOffice being able to load the DB from a spreadsheet by using a copy / paste. 

Can i use SQL to insert?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Multiple Users

For import, you can use free program SQLiteStudio: http://sqlitestudio.pl/
also with help SQLiteStudio you can use SQL to insert data.

Dmitry.