Charlie Coleman >Are you joining those 2 tables in some way? >I don't use Views because I don't like the loss of control. Plus SQL syntax >just isn't good for a lot of situations - and that's all a View really is: >a SQL statement (albeit with some other under-the-hood stuff to send >updates back to the database).
They are not views just tables added to the data enviroment. >Ted Roche >Prove it by copying the files to a local machine and see if they open >much quicker there. If yes, the network is bad. If no, then there's >more problems with the form or the tables. As I said i just created a blank form and added the two tables which are located on another machine on the network. It takes upto 15 seconds for this form to load. They have been have speed issues for a long time and I trying to get to the bottom it. Just to help things along they installed 6 internet phones onto the network as well. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.