If you have Queries in Microsoft Access that link to Microsoft SQL Server 2000, and would like to refer to the Microsoft SQL Server tables while you are linked to the Microsoft Access database through Iron Speed Designer, you will realize that your queries are not visible in the databases section in Iron Speed Designer and no data can be accessed.
Iron Speed Designer currently does not support this scenario. This approach will also have performance problems, concurrency problems and is prone to lock-outs because a user can open the MDB file in exclusive mode denying access to other users in a multi-user environment. It also forces support for the lowest common denominator of the two products – Microsoft SQL Server and Microsoft Access – instead of using the advanced features.
To overcome this issue, we recommend moving the Microsoft Access Queries to Views in Microsoft SQL Server. "Microsoft Access Developers Guide to SQL Server", Sams Publishing is a good book you could refer to for details on how to move Microsoft Access databases to Microsoft SQL Server.
Microsoft Access 2000 Versions
Microsoft Access Database Field Support
Query Support in Microsoft Access
Linked Databases in Microsoft Access
Relative and Absolute Path Names for Microsoft Access Databases
Accessing Microsoft SQL Server Tables through Microsoft Access Queries