In terms of speed, the main consideration is the quantity of data the app is requesting each time it opens the database.
Does your form request all the records in the table each time it opens, or does it just open the table and display one record?
The latter is going to be faster. Using views, can be problematic, if the view downloads the entire table each time it is opened. If your data is on a network server this translates into a lot of network traffic. And the network pipeline can be a substantial throttle on data transfer speed.
Another question is how many users will be accessing the data at the same time, and is there a lot of updates/appends or mostly read only?
MSCE, MCSP, Microsoft Channel Partner
Relax, Boss. We will meet the deadline! What? You want to add MORE? What do you mean, Over Budget?
Opinions and comments are the sole responsibility of the sender, and accuracy, correctness, or pertinence is considered coincidental.
