Hi!

When connecting to database, do not specify exclusive opening of it. This will assure database is accessible by 2 users. You can test it by very simple way - run instances of with your application (or 2 VFP instances running your application when debugging). See if second instance can work with data.

To tst simultaneous insert, set up the button on form with loop checking for certain value in seconds(). When special time occur, do the insert. Then run both programs and activate another Windows application (so OS will give equal processor resources to both VFP applications). Whait for the moment, then see what happens. There should be no conflicts and both records will be inserted correctly.

HTH.

>Im neophite in VFP client/Server Development. Here's my problem: I have a Project Evaluation System that my boss needs me to run in an NT Server so multiple clients can access and evlute the project at the same time. So i placed my Data to the NTSErver but i didn't upsize it to SQL SERVER first co'z i dont know how an second i dont hav much time left to study SQLSERVER for now co'z of the Deadline, So wht i did is install A VFP in NT and test a client if it can access the data. It work, i use ODBC then connection in my GUI. I didn't use remote view's instead i used SQLPassthrough inside the init event of my form in the client computer.
>
>Now here's my question
>
>1. could i Access the Same Database(VFP) in an NT Flatform when 2 client is accessing the data at the same time? would there be conflicts. if so how could i handle that.
>2. Can i Do inserts in the same table, when he insert request is comming from 2 clients at the same time.If not, how could i do that.
>
>Thank's Nancy for the tips.:)