Hello Gary! Yes, Foxpro can run many Foxpro applications at the same time. If you build the application into an EXE and run that from Windows, then there's never any problem. If you run the application from within Foxpro and the Foxpro IDE, then you will need to start multiple instances of Foxpro, 1 per application. I recommend building them into EXEs and running them independently.
Foxpro shares databases! I have had over 200 users all sharing the same Foxpro databases. Of course other SQL databases are also multiuser such as SQL Server, MySQL, PostgreSQL, Oracle, etc. I believe SQLLite is a single user database however. The first thing to consider with a multi-user Foxpro table is how it is opened. If you are using a database container, make sure that the Foxpro setting of "EXCLUSIVE" is OFF. Easy enough: SET EXCLUSIVE OFF <- should go into your application somewhere on startup. When opening tables make sure to open them "SHARED". Easy enough: USE c:\my_app\data\mytable in 0 SHARED AGAIN SELECT MyTable && Selects the MyTable work area BROWSE LAST NOWAIT && Displays the contents for review! If you already have your data in a non-foxpro table, we can walk you through how to connect to it from Foxpro as well. That should get you started. Keep asking the questions. The Foxpro community prides itself with being friendly and helpful. Best of luck! -Kevin Gary Jeurink wrote: > How well does FoxPro run two app's at the same time... oh and heaven forbid, > possibly share a database. If you follow me. My media database has > music/movies/and media-index which is the state of the stereo components and > lights fans etc... > > any recommendations. > > Gary _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
