Can your AccessToCR convert my reports that use linked tables with a SQL Server database?
You can select an OleDB/ODBC option as your target data source on the Connection tab of AccessToCR. Just make sure to use the correct Initial Catalog name in the connection string. The converted reports will be connected to the specified SQL Server database. Note: if you use Access queries in your reports you need to port them to your SQL server as views. You can also convert your Access reports with our AccessToCR’s default target data source first and then open your converted reports in Design View and use the Set Location option under Database on the toolbar to manually change the database to the target data source.
