Hello Shirley, at my currentl position I do a lot of work through an ODBC connection, it happens to be MS SQL server 7.0(I think thats the latest version). I know that through Access you must set up your ODBCConnectStr to set up your connection. However, I am not the administrator of the SQL server. I only see the access side of the "going ons". I would suggest using Access help files(actually quite helpful). Try keywords "pass through query's" and "sql". Also I would head on over to microsoft's website and do some research there under MS SQL Server. If your looking for speed and your company offers you some financial flexibility SQL server is the way to go. <br>
Also, speak with your network admin about setting up a SQL server, see what information he/she can give you. Hope this helps at least a little.