Skip to Content
0
Former Member
Aug 04, 2016 at 09:22 AM

Crystal reports and Access linked tables

99 Views

We are migrating a very old application from Access to SQL Server.

At the moment we are pursuing the use of linked tables in Access, so the application is continuing to talk to Access and the (main) change is that the tables which were previously local Access tables are now linked tables linked to SQL Server.

This approach is proving reasonably successful, as we've found that we only have to make limited and easily identified changes to the code.

The application makes extensive use of Crystal Reports, but so far we've been unable to get the reports to work with Access linked tables. Is this possible, or do we have to redefine each report to link directly to SQL Server (which would be a lot of work)?

Thanks

Jonathan