Hi Tom,

I was of UT a few days so I missed your thread. I have similar problems here! I did tons off stuff to find out what it is. We have spent weeks in this and tried about everything we knew, have heard, have read....

To sum it up:
It seems like Table Commands like Opentables() (DA-Layer), REQUERY()... really slow down to death, when second user locks in.

This is *NO* Mere Mortals problem, the time is really spent in normal Table Commands along the way. It would be great if you would be able do do a coverage validating my results. (Have a close look at the commands in CCURSOR, CDYNAMICVIEWCIURSOR... Classes).

I have this in all environment areas, Changing Servers, Clients... the only thing I really did not try is Win98 on the server. But I will do so !Actually it is nearly 100% sure, that the problem comes from server side and we don't have a solution yet.

We had a network pro investigating the thing and one thing he found out is that when 2nd user is in doing the same action on our app causes 10 times as much traffic as in Single User mode. This could perhaps be rushmores postprocessing, but I am not definitly sure about this.

I would be glad if you would be able to let us know when you found out more. I will do the same.

At UT Thread 815136 we discussed my problem and there were quit a few more ideas, but they did't help in my scenario.

Do you have the link for me where you found the stuff about Access, this would be really interessting for me, because we have Network Pros at customer site that can perhaps have closer look to something like that.

Regards
Marcus

>Temporatily sovled the problem by putting Win98 on the file server. Response is good all the way around. Did find a thread under google where the same problem was encountered with Access97 and Access XP.
>
>Going to let it simmer for a while until I can get some network pro's in to check things out. Thanks for the help and if anybody has any further ideas, would be glad to try them.