Interestingly I experienced something very similar on a Customer's site yesterday. They happen to be on SQL2005, although our packages are Legacy 2000 style DTS packages. Again they had been...

It is also possible to use QUOTENAME to generate the required quote marks for your existing query

Try setting the Password property of the connection instead.

This is 'hidden', and can be set in a disconnected edit.

In the Link Tables dialog, you can select "Save password" checkbox. This will prevent the request for a password in your app.

What often happens when SQL Authentication is used, especially in Novell environments (not sure if you are) is that the Windows authentication to SQL is achieved by mapping a drive...

Sounds more like a permissions problem for your Windows user.

Is it a memeber of the same group where other users are allowed in?

Has it been revoked access to SQLServer perhaps...

If I am right, you are working in Access not SQL so the Change Owner Sp will not work.

All you need do is rename the linked table entries in the...

Have recently been through this process at a number of customer sites.

There is a known problem specific to upgrading to SQL2000 with SP3 applied where your SQL6.5 system...