Hi Frank,

Yes, you're right it could be done in the front-end and probably should (to reduce the load on the server). I was just wandering if I was missing...

Sorry, I didn't word my question clearly.

Getting the line total isn't the problem. Getting an extra row at the end of the recordset with the overall total is the...

I don't think it is a timeout problem as I think SQL Server 7's default is 0 (i.e. no time out). Anyhow, it fails after 4-5 seconds.

I can Select...

Thanks Markus, that got me on the right track. When using sp_defaultdb I had to use the domainname, e.g.:

sp_defaultdb 'DOMAINNAME\Administrator','master'

I have tried to change the default database of Administrator but as I mentioned I get an error message.

Sorry, the client is a linked server connection.

That makes sense. How do I change the settings (I'm a programmer rather than a DBA so apologies for ignorance - please do feel free to teach granma' to...