Data Report Designer using Microsoft Access
Posted on 2004-11-24
I am creating a report using the Micosoft data Report Designer.
If the database.mdb is not password protected, all executes well.
If a password is put on the data base via Microsoft Access Tools, the Report Designer application will not run. (The data base must be protected from access outside the Report Designer application.)
1. If I enter in item 2. (DataLink Properties/Connection Tab) a Password and click "Test Connection", I get the following error message:
"Test connection failed because of an error in initializing provider. Cannot
start your application. The workgroup information file is missing or opened exclusively by another user." Without entering a password I cannot proceed. I have no idea how to make the necessary correction.
2. If I proceed to run the application anyway, I get the "Please enter MS Jet OLE DB Initialization Information" window. After completing the requested entries, I get a blank report and the following error message: "Failed getting Rowset(s) from current data source."
Any assistence will be appreciated.