Re: Link to Access database broken after move to SQL Server 2005
Not so much a bug as a warning. One of the side-effects of swapping to SQL Server 2005 after a Recorder 6 install is that the link to the Access 97 linked database is broken (as I've just realised). The link remains to the original MSDE database. I guess one could manually set up an ODBC link from a new Access DB to the SQL Server 2005 nbndata, though I haven't tried this.
SQL Server Management Studio has a visual Query Designer similar to that in Access, so to some extent this makes the Access linked database redundant. The SQL Server Query Designer does have some limitations compard to the Access one, however, and the version SQL of course differs in some ways.
Alan
Aberystwyth