RE: Inconsistent problem

If the same Excel file uploads properly on your computer but not the
client's; you have the same references; and taking it off the network doesn't
change things, I'm suspecting that computer.

Does it have the same service packs and service releases for both Windows
and Office? The same version of Jet?

I'd also wonder if it has a bad memory module causing random problems.
Anything else buggy on that computer? Have you considered running the process
on a third computer and seeing if it works there? If so, you could have more
confidence that it's a PC problem.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"AlienzDDS" wrote:

OK Now I am really at a loss and really need help.

The references are exactly the same on the clients machine as they are on my
home computer. I have also tried putting the Front End and Back End on the
C: drive of the clients computer and I am still getting intermittent sucess.

I have set up an upload status table that tells me where the file crashed.

1100 2/27/2006 9:08:48 AM Failed on order 620815 Item 41
1100 2/27/2006 9:12:48 AM Successful
1100 2/27/2006 9:36:19 AM Failed on order 620815 Item 40
1100 2/27/2006 9:37:12 AM Failed on order 620815 Item 3
1100 2/27/2006 9:37:55 AM Failed on order 620904 Item 7
1100 2/27/2006 9:38:43 AM Failed on order 620930 Item 1
1100 2/27/2006 9:39:40 AM Successful

As you can see the same order uploaded over and over produces different
results each time. Same order - same code - different results ??????

What is happening is an excel file contains many lines of data. Some are
header info, some are details for many orders. The codes counts the number
of orders in the excel file. Then one by one loads the header info into the
Access fields, then counts how many items are on that order, then cycles
through matching each item in the order with existing inventory and puts it
on the order in Access. Then moves to next order in the excel file.

I am abolutely perplexed. I could post the code but it is very large. I
would really appreciate any ideas. I'm desperate!

Thanks in advance.

Alison.

"AlienzDDS" wrote:

Thanks guys, I'll check references tomorrow.

"Jerry Whittle" wrote:

I bet that G. Vaught is right about the references problem being one of the
problems.

Peer-to-peer is much slower than doing it on a single computer or on a
properly set up network. Also how does your computer measure up to the
client's? I use to keep an old Pentium II machine hooked up to a 10MB network
card just to test databases at home before taking them to a client's
computer.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"AlienzDDS" wrote:

I am having a problem with an upload feature. When I tested it on my own
computer I had no problems. I ran many tests all sucessful. When I loaded
it on the clients computer I had two inconsistent problems. Also the speed
of the upload seemed to be about 10 times slower on the clients computer.

First, it stopped and went to a line of code but without any error message.
The code line was yellow but I was able to continue the code without any
changes. There is no stop request here, so I find this very weird. Running
the same data through the same code the next time was sucessful - no problem.

Two, a similar problem but instead of breaking to code I got a 'No Record'
error. But it didn't take me to debug the code. Again when the same file
was uploaded it was sucessful with no changes.

I do not know how to debug this/these problems since it only happens one out
of five times. And by that I mean I tried uploading the same exact file five
times without making any changes to the file or the code. If I step throught
the code I don't have any problem.

I am wondering if the problem might have something to do with the client set
up. They are peer-to-peer and the back end is on a mapped drive on one of
the computers. Is it possible that if the computer holding the data is busy
that code could timeout?

Thanks in advance.

Alison
.

Relevant Pages

  • Re: Excel File Handling (from Jaydeep)
    ... > Thanks Patrice, ... > Actallty Excel file containts sensitive data and anybody can forget to ... As well there will be button called Upload ... >> obviously no other solution than downloading the file or taking control ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Excel File Handling (from Jaydeep)
    ... Actallty Excel file containts sensitive data and anybody can forget to ... As well there will be button called Upload ... > obviously no other solution than downloading the file or taking control on ... >> uploaded and save the same to the server without downloading the file. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Upload/DownLoad from Excel
    ... Don't catch exception if you don't do anything else than ASP.NET do. ... information in my database by the page. ... this is the code I am using to Upload from sql to excel: ... this works perfectly and I have an excel file on my desktop. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Upload file from USB cable to Mobile Device (PC to Mobile)
    ... I have created another thread regarding exporting data from SDF to Excel file ... application to upload an Excel file from PC to mobile device or from the ... USB cable to achieve the file transfer. ...
    (microsoft.public.dotnet.framework.compactframework)
  • RE: Network Connection Issue?
    ... Intermittent network problems can be very difficult to diagnose. ... Dim procCurrent as String ... Dim FileName as String ... 'time to open an Excel file; ...
    (microsoft.public.access.externaldata)