OK ive done some checking and move the access db to local machine tested and it worked fine, so its got something to do with security account, i blocked the asp.net system account from the local access db and it gave same error, so when unblocked it worked fine, question is now how do i get the asp.net account to work on server 2