then how can I attach my DB without EM to the customers ?

I think you need to install SQL SERVER 2000 Developer Edition .. on win200

let us say that the version refer to technolgy progress (Little or big progress) ... but if yu change a small thing in tecnology (like MDAC) ... you don't need...

what is your FrontEnd application Tool (is it .net .. or Access or what ??

install SP3a for Sql Server 2000 ... and do all the above steps again

if you put it in Master ... then you can use in any database worked on this server .. and of course you need to backup the Master DB frequently...

MAY BE THERE IS A problem in dealing with lock ... the best thing is to run the query on the server (by making Stored Procedure on SQL SERVER) .....

I make a procedure in Access that is check the state of the current connection ... if it is not opened ... then open it again .... and I think...

I make a procedure in Access that is check the state of the current connection ... if it is not opened ... then open it again .... and I think...

SQL Server is more perfect when you Add more RAMS ... and notice that SQL Server uses ALL the Rams that you give to the server... Also you have...

what is your FrontEnd application Tool (is it .net ... then you can sheck for connection) ... or Access or what ??

Note: use Access XP (2002) upsizing wizard .. which is the best tool to transfer data and tables structure to SQL server 2000 ... and then change your connection...

make a System DSN on your machine ... and make it refer to your SQL Database ... then relink tables from Access ... I hope this help you

plese send more details ... like ... what is your application FrontEnd tool ?? is it Access ??

I think the best way is to use Access 2002 (XP) upsizing wizard to send the table ... then update your new table from this table .. by an update...