I am in the process of updating the database location on our reports. I have been successful with all but one report that when I set the database to the new location I get 2 errors. "Failed to open a rowset" and "Invalid Arguement provided". I deleted and replaced the links from each table - that didn;'t help. I tried a bunch of other things and started looking more closely at the way the two reports linked the tables and noticed something strange. The tables have different colored index fields. The same field in the same table on each report has different colored indexes. I am not explaining that well but hopefully someone can explain to me how they can change. It's the same database, same tables, same fields different server.
Thanks,
Karen