Thanks a lot Andy the registry key was there but i finally find client tools you say at c:\Winnt\system32\cliconf.exe to use TCPIP as default.

I am now using msde on my computer, and it did not have any client with it. I think this is the problem, anyway it is strange MS did...

Thanks I will then go for first solution.

Well let me explain my problem.

I have to receive data form various stores, the database have to handle sales, storage and manufacturing. SaleItems Table will grow more than 1,5 million...

Thanks, for the answer. I am using all of this tables becouse they are controled on the same object, they are all the same structure but different names, then it...