PMFJI, you don't have to comment out any code. You can subclass CtrApp and change the call in your application specific SetUpTables method to pass a .T. as the 2nd parameter to oLib.oDBCSvc.OpenData. This will tell the database service object to only open the database and not its contained tables.

WRT the tables not refreshing, VMP sets REFRESH to 0,60 by default which means you have to wait 60 seconds before the memory buffered tables on your PC are updated with the latest data from the network. In my last app, 1 minute delays were unacceptable. I subclassed CtrApp and put the following code in my SetUpSets:

ctrapp::SetUpSets()

set refresh to 0,12

I used 12 seconds but you can make it any number you want. Remember, this command will increase network traffic the smaller the 2nd parameter, so you may have to do some experimenting to determine what is a good scenario for you.

>In VMP all tables are opened in the default datasession. The forms seem to use these tables with a 'use again' default. We found that we had to comment out all the code that loaded the tables into the default DS, and then the refresh worked as expected for VFP tables. AFAIK, however, Views will have to be refreshed by you. I don't know of any way to automate refreshing a view except with a timer. Hopefully somebody smarter will jump in with the answer to the view refreshing.
>
>HTH
>Barbara
>
>>I have a system I have been working on for quite some time. Today I put it to its first multi-user test. I put it on a network of about 20 computers. Right away I noticed a problem. If I add inventory records on Computer A, and then go to Computer B those same inventory records don't show up if I try to pull them up in my order form. I further noticed that if I then select the table and then browse the table and then get back out of the table, the records can then be found on Computer B.
>>
>>I am using Visual Maxframe Professional. I am using views in the inventory entry form. In the data environment both, the view and the base table have a buffermodeoverride of 5.
>>
>>Any help would be greatly appreciated.
>>
>>Thank you ,
>>Paul Acton