SQL Server ODBC Connection

How can I program the UserID and Password into a VBA application (Access97) so that the client using the front end doesn’t need to enter password (and will not know what it is) . The user can only get into the tables the program allows.