AlexBg
asked on
Use Crystal Report on .MDE file
Is it possible to use Crystal Report 8.5 on a Ms Access 2k .mde files.
when i try to link a new report with my mde file its doesn't work.
Thanl You
when i try to link a new report with my mde file its doesn't work.
Thanl You
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the solution on seagate site
Solution
Renaming the file extension from MDE to MDB allowed reporting off this file while protecting the Access coding within the file at the same time. Seagate Crystal Reports(SCR) does not support MDE files. Even after the file association for MDE files was removed, SCR could not report off an MDE file.
Solution
Renaming the file extension from MDE to MDB allowed reporting off this file while protecting the Access coding within the file at the same time. Seagate Crystal Reports(SCR) does not support MDE files. Even after the file association for MDE files was removed, SCR could not report off an MDE file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Vous ne pouvez pas créer un fichier MDE dans Microsoft Access 2002 à partir d'une base de données crée dans une version plus ancienne. Vous ne pouvez enregistrer un fichier MDE à partir d'une base de données qu'en travaillant avec la même version d'Access.
means you cannot build a mde file with an older version of access
then (Edited by Computer101) mde files
thank you guys
means you cannot build a mde file with an older version of access
then (Edited by Computer101) mde files
thank you guys
Just to say that Crystal Reports V9 can use .mde files.
Pete
Pete
Just a sidenote.
If you are using MsAcces, Chrystal and .mde files, you sometimes get the error: Could not open server. Whenever this happends it indicates that the reports wants to log into the database. I have learned that there is an admin user by default in the database BUT depending on your local language settings, this user is not by default used by the chrystal engine. (Sometimes it wants to log into the database using the "Beheerder" as default which is the dutch word for admin. To solve this, make an odbc connection to the mde file and enter a userid and password in the odbc connection. Chrystal will detect this username and pw and will use that in stead of the local language preferred userid.
I searched all the inet for this fix and eventually found it out by accident. :o) Dunno if this is the right section to post it in. Just want to share knowledge.
If you are using MsAcces, Chrystal and .mde files, you sometimes get the error: Could not open server. Whenever this happends it indicates that the reports wants to log into the database. I have learned that there is an admin user by default in the database BUT depending on your local language settings, this user is not by default used by the chrystal engine. (Sometimes it wants to log into the database using the "Beheerder" as default which is the dutch word for admin. To solve this, make an odbc connection to the mde file and enter a userid and password in the odbc connection. Chrystal will detect this username and pw and will use that in stead of the local language preferred userid.
I searched all the inet for this fix and eventually found it out by accident. :o) Dunno if this is the right section to post it in. Just want to share knowledge.
ASKER
To make an MDE application linked with an access database, the database must be a mde files... MDE are not just to protect the forms?
thank you for the tips I'll try with a password
AlexBg