The instructions above do not pertain to Access 2007. Thanks to MS, they totally changed the interface and things with all of Office 2007 to bring office productivity to...

Thanks for the input and realizing the security issue you bring up, I created a userid/password that has very limited use in the DB, etc. So, even if they...

Thanks for your reply to this. As you might have seen from my id, I am a bit of a newbie to Access and SQL Server and VBA. ...

THANKS! This concept worked. It took me awhile to figure out how to reset the ODBC, so I will try to clarify how to do this.

1. Deleted all...