are you working with DAO or ADO in Access?

I'm almost certain that DAO only supports one set of data returned

SQL Stripes? What is it?

Hello,

I've got no experience with clusters yet.

But there is an article in MS knowlegdebase that discusses how msdtc should be configured on a win 2003 cluster

http://support.microsoft.com/default.aspx?scid=kb;en-us;301600

perhaps you need this...

Inserting in a table yields no order (like throwing stuff all in a big bag)

Order is done via your query/stored procedure ...

On what OS are the sql servers operating?

There might be some issue with the new features (rpc security) msdtc got with windows 2003.

According to this site, it is because sqlserver service...

On what OS & servicepack is your SQL-server (servicepack?) running?