Hello People,
I made a data base with secure wizard to provide to users a PID and Passwords. I need to extract data from Crystal Reports 7 in this data base but Crystal Reports send me a message like I cant extract data because I don't have rights to this data base. I am the "Admin" I don't Know what happens in this case.
I try to change the "Set Location" in Crystal Rpts but no results.
Crystal don't show me any window to put the "Password" to admin in the data base.
Hola Gente,
Tengo una base de datos en Access 2003. Cree una sección de "Passwords" para los usuarios a través del "Security Wizard". Cuando trato de conectar "Crystal Reports" a la base de datos me dice que no tengo los derechos de extraer datos. Yo soy el administrador de la base de datos.
Trate de cambiar en la opción "Set Location" en Crystal Reports pero no da resultados.
Crystal tampoco muestra alguna ventana donde pueda entrar algún "Password" para poder entrar a la base de datos.
Thanks for any Answer......
5 3569
Hola, ElTipo...
Can you connect using the Import function from within Access?
¿Puede conectar de entre Access usando el 'Import' función?
Regards,
Scott
Hola, ElTipo...
Can you connect using the Import function from within Access?
¿Puede conectar de entre Access usando el 'Import' función?
Regards,
Scott
Hi Scott,
Sorry for my late..
Ok, I use the Crystal Rpt tool by running one file Sysdb32.exe and selecting the access Systm.mdw file. In this way the program will look to Systm.mdw when opening data base and the user will be prompted for access password. This version is old 7 Seagate.
What is the import function? this is other form to connect?
Let me know and thanks again!
My thought was to open Access, go to the File Menu > Get External Data > Import.
This brings up a file dialog box where you can navigate to the Crystal Report in question and import into Access.
Are you trying to set up a dynamic linking situation where users can do this repeatedly, or are you doing this one time only to get data from an old Crystal Report into Access to be used from now on in Access?
Regards
Scott
My thought was to open Access, go to the File Menu > Get External Data > Import.
This brings up a file dialog box where you can navigate to the Crystal Report in question and import into Access.
Are you trying to set up a dynamic linking situation where users can do this repeatedly, or are you doing this one time only to get data from an old Crystal Report into Access to be used from now on in Access?
Regards
Scott
Hello Scott, thanks for your answer.
Yes, where users can do this repeatedly. They use the reports and agree with their password.
Hello Scott, thanks for your answer.
Yes, where users can do this repeatedly. They use the reports and agree with their password.
I'm not an expert with Crystal Reports! Sorry... This is what I was able to find browsing through their online support knowledge base. http://technicalsupport.businessobje...contextType=gs
KBase Article ID:c2008815
Article refers to:Crystal Reports 8
Symptom
In the version 8 Crystal Reports Designer, how do you establish an OLE DB connection to a Microsoft Access database that contains database level security?
Resolution
To establish an OLE DB connection to an Access database containing database level security:
1. In the Crystal Reports Designer, click 'File' then 'New'. Click 'As a Blank Report' from the 'Crystal Report Gallery' then click 'OK'.
2. The 'Data Explorer' appears. Click on 'More Data Sources' and then 'OLE DB'. Double click on 'Make New Connection'.
3. The 'Data Link Properties' dialog box appears. Under the 'Provider' tab, highlight 'Microsoft Jet 4.0 OLE DB Provider'.
4. Click on the 'Connection' tab and browse to your Access database.
5. Click on the 'All' tab. Highlight 'Jet OLEDB: Database Password' and double click it. In the property value, enter the database level password. Click 'OK'.
6. Go back to the 'Connection' tab and click 'Test Connection'. You should see a 'Test connection succeeded' message box.
You can now successfully connect through OLE DB to your Access database (containing database level security).
Document Type:
Knowledge Base Article
Product Major Version:
Crystal Reports 8
I'll ask around to see if anyone else has a better handle on this.
Regards,
Scott
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Rick Thiel |
last post by:
Hello,
I am trying to build a Crystal report VisualStudio.NET for an ASP.NET
application. I would like to build a report that doesn't connect to
any particular database at design time because I...
|
by: Grant Stanley |
last post by:
I'm developing an application in VS.Net 2003 using C#, which uses Crystal
Reports.
When creating each report, crystal asks where the database to use is, so I
specify our SQL server using the ADO...
|
by: DCraig |
last post by:
I'm having problems printing to a line printer from both Crystal Reports and
SQL Server reporting services using dotnet. When I try and print a report
from an application with Crystal I get the...
|
by: GC |
last post by:
HI,
I'am using Crystal Report with visual Studio .NEt 2003
When i make a report using a store procedure, I can not see all the fields
of the store proc and i'm suppose to see those fields. I'm...
|
by: Raghuraman |
last post by:
Hai
I have a designed Crystal report .rpt file which has 4 access tables
.. After designing the report i put a parameter field which filteres
the desired records quite naturally. Every thing...
|
by: |
last post by:
Hi,
I am loading some crystal reports in a method similar to this (see below).
And set the cursor to waiting while the reoprt is loaded, run and shown.
BUT while the report is running the cursor...
|
by: Dave McKie |
last post by:
Hi all,
I am trying to do my first Crystal Report with the bundled version of
VB.Net version 2003. I am familiar with creating reports in Crystal
version 9...so I though it would be a piece of...
|
by: Tyranno.Lex |
last post by:
I am using Visual Studio .NET 2003 and have successfully deployed a
commercial web application written in C# and ASP.NET. I am now wanting
to add reporting using Crystal Reports and am having a...
|
by: Marc Castrechini |
last post by:
We have recently setup a new server:
Windows 2003 (Version 5.2)
IIS 6.0
ASP.NET 2.0
Using existing code that previously worked we can't seem to export PDFs from
our Crystal reports anymore...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |