Ok,

My misunderstanding. It seems that in 2000 MS became aware of a
loophole in the security for documents containing data acquired through
a DSN as the document was saving the connection details (including
password) in the file in plain text. When the SR-1/SR-1a was released
they disabled this feature.

To their credit they did allow the user to manually override this new
setting and continue to save the un-encrypted connection details with
the file, but then why would you want to?

It was this fix that was causing me problems as I wasn't expecting it.
Now that I know what's going on I can find a new way to share my data.

If you are reading this and want to override the fix then simply right
click your data in the document and select properties. I think the
second option is to save password in file which when checked will do
just that. There is also a registry key that will set this flag by
default if you realy need to.

<M