Thanks for the info bill. Actually we were able to speed up the app significantly (access a record went from 25 sec to 6 on a P166) by using views instead of the accessing the table directly. But here's my new question: We are using local views and then accessing them like you said (nodataonload and then define the parameter and then requery()). What is the difference with a remote view? We only use one DBC for the App wich is on a Novell file server.

Thanks Bill & All who contribute
Shawn Burke
DRI Management Systems