Data Report Designer using Microsoft Access

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.)

More information:
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.



sigreeneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ajgilbertCommented:
Try the following...


Go to the dataenvironment connection. Open the connection properties window, go the the Connection tab and enter the database password. Make sure that the Allow Password Saving check box is checked.





0
ajgilbertCommented:
Sorry, submitted too soon...

You also need to make sure that the database user entered on the connection tab is a valid user for the database in question.

0
ajgilbertCommented:
And if that does not work, then do the following...


Remove the information in the connection tab (i.e. database name and password). Go to the All tab, and enter the information against the following items...

Data Source
Jet OLEDB: Database Password

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sigreeneAuthor Commented:
I had previously tried your first two suggestions, these did not work.
However, your suggestion to enter the password @ Jet OLEDB: Database  Password did the trick!

Thank You ajgilbert! You deserve the 500 points and an A rating!

0
ajgilbertCommented:
Thanks Sigreene, glad to be of help.

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.