WOW... you probably don't even need CDXs on THAT config < s >! I suppose it's running SCSI RAID 5 too.



>I've had SQL 2000 running on lesser servers. A server with Two 1.6 Gig processors and 2 gigs of RAM that has 30 users accessing VFP tables. Nothing else is on the server. The server has a GigaBit connection to the Gigabit switch. The largest table has less than 50,000 records and only 20 fields.
>
>I am still cleaning up indexing but I just want to eliminate any possible reasons for speed problems.
>
>
>
>>I'd say it shouldn't be a problem if the file server has lots of RAM (and is not peer-to-peer).
>>
>>I guess there can be instants when something may be noticed, depending on how much data is pulled for the ACCESS reporting at any given time.
>>
>>
>>
>>>I have a client with a VFP 6.0 app. The tables are also being accessed via MS Access for reporting. Will MS Access affect the speed of VFP accessing the data? The tables are all free tables if that makes a difference.
>>>
>>>Help is appreciated.