[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Data Report Designer using Microsoft Access

Posted on 2004-11-24
Medium Priority
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
  • 4

Expert Comment

ID: 12673062
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.


Expert Comment

ID: 12673100
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.


Accepted Solution

ajgilbert earned 2000 total points
ID: 12673214
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

ID: 12676231
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!


Expert Comment

ID: 12679686
Thanks Sigreene, glad to be of help.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month20 days, 2 hours left to enroll

873 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