I have an access adp (2007) and SQL Server database (2005). For some reason, when I create a stored procedure in SQL Server, it does not always show up in the Access ADP. So I tried to sync the two entities to make sure that data, stored procedures, and
functions were identical in SQL Server and the ADP, but I am unable to click on synchronize whe I click on Home->Refresh All. The button is not activated.
How do I sync data, stored procedures, and functions between both entities?
View Complete Post