Problem getting external data using Access

Hello.
I would appreciate any assistance in finding a solution to this problem.
I am using an access program that connects to an access database. The
program was written using Access 2000. However, the program does not properly
connect to the database, depending on the computer on which it is installed,
or the operating system of the computer on which the program has been
installed.
For example, the connection fails on any computer that uses Windows 98. It
works for the most part on computers using Windows 2000, any version, but it
failed to connect properly on a Toshiba laptop computer that had Windows 2000.
The program opens properly, but the data that should appear from the
database cannot be accessed. The database records are hidden by the program,
and can be viewed when the database is unhidden. Nonetheless, the records
cannot be manipulated by the program.
Thank you very much in advance for your time and suggestions.
Regards,
The Seefahrer
If you have Access program installed on the computer, then use it to
determine if there are any problems with opening the .mdb file that you
want to access. Check for error messages as they provide insight into what
the problem could be.
James
***Disclaimer: This posting is provided "as is" with no warranties and
confers no rights.***
--
>Thread-Topic: Problem getting external data using Access
>thread-index: AcTmMQytVaJhB1ULSXmwYuabzWov8w==
>X-WBNR-Posting-Host: 4.159.163.153
>From: =?Utf-8?B?U2VlZmFocmVy?= <Seefahrer@.discussions.microsoft.com>
>Subject: Problem getting external data using Access
>Date: Sun, 19 Dec 2004 17:13:01 -0800
>Lines: 24
>Message-ID: <C5C0E0CF-3D41-4692-9AE8-623A3A761827@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.connect
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.connect:44010
>X-Tomcat-NG: microsoft.public.sqlserver.connect
>Hello.
>I would appreciate any assistance in finding a solution to this problem.
>I am using an access program that connects to an access database. The
>program was written using Access 2000. However, the program does not
properly
>connect to the database, depending on the computer on which it is
installed,
>or the operating system of the computer on which the program has been
>installed.
>For example, the connection fails on any computer that uses Windows 98. It
>works for the most part on computers using Windows 2000, any version, but
it
>failed to connect properly on a Toshiba laptop computer that had Windows
2000.
>The program opens properly, but the data that should appear from the
>database cannot be accessed. The database records are hidden by the
program,
>and can be viewed when the database is unhidden. Nonetheless, the records
>cannot be manipulated by the program.
>Thank you very much in advance for your time and suggestions.
>--
>Regards,
>The Seefahrer
>

Problem Export - Works on dev computer, not on other ones...

I have a problem exporting report with Crystal Report for Visual Studio .NET 2002.
In fact, with the computer I used to program, the export works fine. I've tried to get my .NET project on another computer, and there the export doesn't work...
The error occurs on the line : report.Export(); When I catch it, it says "Echec de connexion", which means "Connection failed".

Here are my config :

- The "good" computer : Win 2000 Server with last SP's, VS.NET 2002, Crystal Report for VS .NET

- The "bad" one : same one...

I also tried on an Xp computer, and it doesn't work either...

I've tried the Modules utility from Business Object to see if DLL's were missing on "bad" computer, but it's quite hard to define ('have to see the DLL under aspnet_wp.exe process, haven't I ?)

I install all services packs and hotfixes for Crystal Report for VS .NET 2002...It doesn't change anything.

So, if you have any idea, it would be welcomed !! Thanks.Check to make sure all the required Export dlls are installed on the "bad" computer.

Each Export format (Excel, pdf, etc) and each Export Destination (Aplication, Disk, etc) has to have a dll installed on the machine it's running on. If, for example, you can export to pdf, but not to Excel, your problem may be that the dll required for Excel Export is missing.

In Crystal Reports 8.5, there's a file called runtime.hlp that tells exactly what dlls are required depending on what your application uses.

(Ex. For CR 8.5 and Win2k, my Excel export dll is: C:\WINNT\Crystal\u2fxls.dll and my dll for Exporting to Application is: C:\WINNT\Crystal\u2dapp.dll)