If you want to find out what service pack your sql server is on type

select @@version

in query analyser. This gives you a number which refers to the service pack

...

What is the error message you get?

It may be your netlibrarys not matching up between the two machines.

For instance if the error message contains dbmssocn it means your pc is...

It may be worth you stopping and starting SQL server, as this recreates your tempdb database from scratch. Hence giving you a clean starting place.

Access 2000 ADP front ends may be worth investigating as well

Try capturing what code sql enterprise manager uses to modify the table.

ie run profiler against your test database, change the table via enterprise manager,then review your connection information in the...

Sorted. I needed to check the 'binary' column in the defined destination column