Data Report Designer using Microsoft Access

Posted on 2004-11-24
Last Modified: 2013-12-25
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.

Question by:sigreene
    LVL 5

    Expert Comment

    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.

    LVL 5

    Expert Comment

    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.

    LVL 5

    Accepted Solution

    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


    Author Comment

    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!

    LVL 5

    Expert Comment

    Thanks Sigreene, glad to be of help.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    Introduction In a recent article ( for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
    Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now