How do i connect to SQL Server within Access 2007 - Create ADP File
Looks like easy, it is, but the IDE changed a lot so goes the post
1. Choose create a new Black Database
2. Click the Button Browse for Files


3. Save Your File as ADP then Connect normaly to SQL Credentials to an Existing or create a new Database
Cheers