I am building a small piece of code using access 2007 that would automate some updating of data. This small access is to be run by a scheduler. And I have run into a scenario wherein I would like to suppress the window prompt that asks for the username and password to connect to the SQL Server database. Are there any sample codes that would connect to SQL Server?

Thanks,
Warren