• Registered: 2014-07-02
  • Posts: 3

Topic: Databases

hi, two quiestions
1.- Where  are the databases?
2.- Can they use by many users at time?
thanks

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

Re: Databases

Hello,

1.Here you can find some databases
http://myvisualdatabase.com/database_examples.html


2. Yes, you can use on local network by many users at time.

Dmitry.
  • Registered: 2014-07-02
  • Posts: 3

Re: Databases

Thanks!
Another question..
i want to import my data into a new myvisualdatabase app.
i have a csv file and i´ve tried to import into a sqlite.db via sqlsutdio but i can not join the sqlite.db with the app

what it´s wrong?

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

Re: Databases

jcsanpelayo

Please, send me your project and csv file to support@drive-software.com

I'll try to help you.
Thanks.

Dmitry.
  • Registered: 2014-06-07
  • Posts: 6

Re: Databases

Just to clarify this...

If I have a .mdb file or other database file in a LAN drive, then there is nothing more to do for multiple users? I just have my app installed to every PC and everyone can access the file at the same time?

I know nothing about database servers etc... so I need to have a positive answer...
What do I have to do when I need 1 database file and many users that can access the file at the same time?

  • Registered: 2014-07-02
  • Posts: 3

Re: Databases

i think could be better if you create a new video lessons to explain how to create an app and import data.
so then you dont need to answer indvidually.

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

Re: Databases

jtbxxxxx
Exactly, you can use one database file on LAN for access many users at the same time.

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

Re: Databases

jcsanpelayo
Yes, i know )

Dmitry.
  • Registered: 2014-08-07
  • Posts: 13

Re: Databases

Ok. I read in the SQlite FAQ that multiple systems can access the database on a network server but only one "edit" can be made at a given time..

The problem is the database I am building is intended to be used by at least 70 people at the same time.

http://www.sqlite.org/faq.html#q5

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

Re: Databases

napsanti
I do not recommend to use My Visual Database in your case, or test the work of the database in your organization,
for this you can use any database of examples
http://myvisualdatabase.com/database_examples.html

Dmitry.
  • Registered: 2014-08-07
  • Posts: 13

Re: Databases

Yeah, I figured as much. I guess it would be much of a hassle to use a different database.

No work around though, right? like save data on a self contained database and a button to mass import the data to a central database?

By the way, I made the login for password work for me. It feels awesome. Since the work database project won't happen, I guess I could just make a database for my movies. big_smile