My current environment is set up from a SP teamsite that I have current admin rights on. I want to have a SQL Server external DB update my SP list on my teamsite dynamically. My idea is that I am creating a WebApp GUI for people to update the SQL Server database from views that is the exact copy of the data in the SP list. When a user updates the data, my question is can I use SP designer to have the SP List on the teamsite to point to the SQL server external DB thats connected to the WebApp GUI, so that when the tables are updated the list is automatically updated. I believe Visual Studio could easily do that with creating a custom webpart, but my question is could Sharepoint designer 2007 accomplish this.
Let me know if I made my question clear enough.