Access Database via ODBC Connection

[Bennie47250]

Attempting to run a Crystal report from a 3rd party tool (rePORTAL), that uses an Access database as the source.
We are using ODBC to connect to the table. If the Access database is open, the report is unable to login.

Any thoughts on how to be able to run the report even if the database is open in another application?

Thanks
Bennie

 

[kray4660]

It almost sounds like a record locking issue with the database. I do not remember the various options, but one of them should allow sharing of the database by multiple users. We have a couple of Access databases that we connect to for reports and we do not have the issue.