ok, i have checked and excel is not open, i can edit and save etc ok and no excel process's are running

i have also shared the folder with full privileges...

yea on a server - server 2003

not supported? maybe not officially - iv no idea

but i never have had issues before and iv used on server 2000, 2003,2008?

how else would...

hi oleg

i will try your suggestions tomorrow, i think you may be more correct on the security /permissions though, as excel definitely was closed any time i tried to run...

hi Rob

yea thats whats happening it seems,

i thought maybe it was being updated as a batch first of all as well but again as you say its done line...

i have free fields on the table in question, i think i will simply run with that,

thanks for advice tho!

yea its the same version office 2003,

and everything is 32 bit

hmm, i cant do this can i? unless i update after the first email?

Excellant!

works a treat!

cheers Shabba

just before i do (overly cautious again)

this will not make any changes to the live system? - just produces a script that i can run on test and recreate...

ok, i now have the 2005 - 2005 script!

error:

Msg 208, Level 16, State 1, Procedure sp_help_revlogin_2000_to_2005, Line 19

Invalid object name 'master.dbo.sysxlogins'.

cheers shabba, will give it a try now

to recreate, do i need to delete the user from all the databases user entries first?

i havnt created any..

the db users moved with the restore

ok, i see that the users also copyed across already with the database restores,

but should i delete and set them up again? as they do not show in \\security>logins ?