Originally we had the database on an NT4 server w/ all NT4 work stations running it locally - one of the first things we did was make sure all the WS's were runnning the same Windows & latest SP - we were getting a corruption message approx. once per month - most times repairing the corruption didn't result in any data loss - but if it did we had to rebuild the database from the last B/U or just use the last B/U as is.
We recently switched to a small dedicated Win2000 terminal server & have the WS's log into dumb sessions - so far weve had no corruption issues - although I must admit I find the whole W2K Server/terminal server licencing set up to be a real pain/semi-mystery - if you know of any good Win2000 Terminal Server reference resources - I would be forever in your debt.
teminal server is a much better enviroment for this app. - you don't have a 150MB database files flying all over the network & colliding at the server - much better/faster performance & we even set up a couple of old P90's as dumb terminals in the boardroom - the min. requirement to run the software locally is 300MHz
the Application is called JobBOSS - the company is based in Mn,USA - they have both an Access & SQL solution with the same/similar front end interface.
Where I work - we don't have anybody with formal IT training - i'ts mostly learn-by-doing, for myself and one other employee, so it can be frustrating at times
We recently switched to a small dedicated Win2000 terminal server & have the WS's log into dumb sessions - so far weve had no corruption issues - although I must admit I find the whole W2K Server/terminal server licencing set up to be a real pain/semi-mystery - if you know of any good Win2000 Terminal Server reference resources - I would be forever in your debt.
teminal server is a much better enviroment for this app. - you don't have a 150MB database files flying all over the network & colliding at the server - much better/faster performance & we even set up a couple of old P90's as dumb terminals in the boardroom - the min. requirement to run the software locally is 300MHz
the Application is called JobBOSS - the company is based in Mn,USA - they have both an Access & SQL solution with the same/similar front end interface.
Where I work - we don't have anybody with formal IT training - i'ts mostly learn-by-doing, for myself and one other employee, so it can be frustrating at times
Comment