Can someone tell me the best way to use My Access queries and forms with a
SQL Server 2005 DB

[quoted text, click to view]

What does "best" mean to you? The key to building a robust, scalable
solution is to put the data processing logic onto the database server and
leave the client application to handle user interaction. Typically that
means you create parameterized SQL stored procedures for all your data
access needs instead of executing queries directly from Access. Using stored
procs you can ensure optimal performance and reliability for whatever type
of client you choose, whether that's Access or .NET or ASP or something
else.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--