Here's your responses to my questions. I'll add my answers to them.

1. I don't know the difference between hubs or switches
A: Simplified Answer: When a hub recieves a data packet, it doesn't exactly know what computer is to recieve that packet. So it broadcasts the header of the packet to every connection on your network. If you have ever watched the lights on your hub and they seem to flash together like in rythem, that is basically broadcasts of packets trying to find their destination.

Switches on the other had are somewhat intelligent. When a switch recieves a data packet, it looks at the header to see what ip address or node address to forward the packet to. So instead of broadcasting to every network connection to find the right destination, it forwards the packet directly to the correct machine. Most switches have an internal routing table, that builds and overwrites itself as data packets flow through it. Using switches instead of hubs can yield an enourmous speed gain on a network of almost any size. Exspecially on a ten user network that is running data applications and internet / email applications.


2. How can I verify if it's 10BT or 100BT it's not Fiber for sure, don't have money for that.
A: Yea, Fiber can be expensive. Ok, first off...look at your hub or switch. Most of them will say it or wrap it in the model number. If you can't find, post the brand and model number. Same goes with your network cards. On the back of your network card, most vendors stamp what each light means.

3. I'm using a shered database, all my user connect to it.
A: Let me rephrase the question. Are you using SQL commands or the following:

USE xDatabase SHARED

Using SQL to decrease the returned recordset has been in my experience alot faster than using the main database. Use the SQL to place the data in a temp database or cursor. So, what this means is instead of opening a copy of all 40,000 records on each workstation, you open only the ones that meet the search criteria.


4. Sorry Doug, I'm not sure about the server specs. There is one other application other then this one.
Q: Is this a Windows NT server, Novell, AS-400?
Q: Is there one processor or two?
Q: One or two network cards?
Q: Ho much Ram is in the system? (This is a big one for depending upon how many total users you have.)


Anyways, it's my bedtime. I'll check back tommorrow morning.