Linked Table Won't Open

Hey guys, I have an Access DB that has a linked table to a SQL Anywhere DB. When I try to access this Access DB, it prompts me the first time every time for username and password to the SQLA DB. This isn't a problem when it is just me that is working on development, however, I figured MS would have something good to say about this issue, so that my users can use this DB as well. MS says I need to pre-open the table using the same credentials for both DB's. I have tried this several ways, and am still unable to open the linked access DB. The error I get is that the DSN=xsellvehicles (this is the DSN that is used by Access to open the table that resides in SQLA) can't be used because the username or password doesn't work.

Any ideas? I need to keep the linked table, because I do a bunch of calcs in Access on the table before it goes to the web.

Are you using at least Access 2000? If so try using .ADP instead of .MDB if possible. The only other way to solve this, is to send a valid username and password to the login every time the table is opened.