Rowsource not updating
To enable tracing of all ODBC commands from the Jet database engine: After making this change in the registry, queries submitted to any ODBC data source are logged in a text file named
Most of these issues relate to performance or updatability.
Developers often migrate data to SQL Server expecting an improvement in application performance.
Although performance does often improve, there are many cases where it remains the same or even degrades.
Andy Baron November 2006 Applies to: Microsoft SQL Server 2005 Summary: One way to create applications that use Microsoft Office Access for creating user interfaces and that use Microsoft SQL Server for data storage is to link Office Access tables to SQL Server tables.
This is the type of application created by using the SQL Server Migration Assistant for Office Access.