>Hello,
>
>I wonder what is the maximum number of simultaneous users (opening the same database table) in a local network and/or terminal server environment with native fox pro tables.
>
>I'm considering about 50 to 100 users starting the same .exe application with the same vfp database. The application will be started from different computers within the network - the database resides on one server (fast network speed 1000MBit).
>
>Each users may have open 30 tables at a time.
>
>Upgrading to an SQL server is not an option.
>
>Are there any experiences regarding the limits of native vfp databases (VFP 8) and tables.
>
>Thanks in advance.
>
>Andreas
There is no limit in VFP as to how many users can use tables, but you will see a gradual decrease in the performance as more and more users use them.