Linking to an Access Database

[Ohioste]

I'm trying to link an access database to table in a Warehouse Management system.

The customer provides projected sales in an Excel spreadsheet and I imported into an access database. Before hand, I created fields that could be linked to my WM databases.

I have five fields that need to be linked:
STYL, SSFX, COLR, CSFX, SDIM.

The access database has just over 9000 lines.

The WM report has over 100,000 records.

Just bringing in one thing from the access database and WM database makes the report take hours to run. Just searching for one SKU.

This is the first time I have used access in Crystal.

Is there a simple thing I'm forgetting?

 

[Ohioste]

Over 400,000 records to be accurate.

 

[jmd0252]

You want to establish a new connection, specify access and browse to it's location. Where are you having problems??