Changing data source from ODBC to Access

[Icebun]

Hi all,

I have a report based on five SQL tables which I am querying using ODBC.

I've made a copy of the tables in an Access database so that we can continue to run the report on a laptop.

I now need to do a 'Set Location' in the crystal report so that it points to the Access database, rather than the SQL tables.

When I try this, the 'Database File' button is grayed out - it will only let me use the tables from the SQL data source.

Any ideas ?

 

[dgillz]

Click on database, convert database driver, and point to the proper driver. Let me know if you have any questions. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[synapsevampire]

Also, ODBC is available for Access, you don't need to convert drivers.

Create the ODBC to the Access database, and use Set Location to point to the new source.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Icebun]

OK, I've tried doing this using both suggestions above :

1. When I try using 'convert database driver' and then 'file system', Crystal lets me select the folder where the mdb file is located, but not the actual file (there are 2 mdb files in the folder).

2. If I use the ODBC- MS Access driver, I get a 'physcial database not found' error on the laptop when i try to run the compiled report. I've distributed the correct drivers for it.

Any ideas ?