can't upload msaccess dbase, connection resets

R

Robert Blackwell

I have this CRAZY problem. I've had it in the past and have never been able
to resolve it. I have an access dbase (i think it's 2000 format)

This is a very strange situation. It appears to reject mdb files only
because I have tried uploading psd's, mp3's and self extracting exe's of
various sizes from a fewk to 10MB.

my access dbase is almost 6MB. When I upload something happends and only
half of it gets uploaded. This happend with my old host too, but with a
different dbase file.

I'm using FTPX (free ftp client) It uploads and gets to 44% and then just
stops at 44% for a while. Eventually it will just stop..put an incomplete
file on the server (apx 2.6MB) and that's it. Dreamweaver's FTP will do the
same thing, exccept it freezes at a different % on the upload.


here is my ftp log

SYST
215 UNIX Type: L8
CWD /c:/webhost4life_aspnet/robbieb/thephotoshoplounge.com/data/
250 Directory changed to
/c:/webhost4life_aspnet/robbieb/thephotoshoplounge.com/data
TYPE I
200 Type set to I.
PORT 192,168,2,27,6,248
200 PORT Command successful.
STOR pslounge.mdb
150 Opening BINARY mode data connection for pslounge.mdb.
pslounge.mdb transfer incomplete
426-Maximum disk quota limited to 500000 Kbytes
Used disk quota 192292 Kbytes, available 307707 Kbytes
426 Data connection closed, receive file pslounge.mdb aborted.
TYPE A
200 Type set to A.
PORT 192,168,2,27,7,12
200 PORT Command successful.
LIST
150 Opening ASCII mode data connection for /bin/ls.
226-Maximum disk quota limited to 500000 Kbytes
Used disk quota 192292 Kbytes, available 307707 Kbytes
226 Transfer complete.


I have a total of 300MB on my host, and I'm only using 220MB
any ideas???
 
R

Robert Blackwell

I just now tried uploading an 18MB dbase and this time it stopped at 2240KB
but the ftp log is basically the same thing.
 
H

HSalim

are you saying that you can upload other files that are larger, just cant
upload access mdbs?
Have you considered zipping up the mdb before uploading? and Compacting
before zipping?
That should get rid of the .mdb problem and reduce the size.

if that does not work, split the zip file into multiple disks and upload say
2mb at a time

IT may be that the FTP server uses an interim folder to write the data as it
comes in - typically a temp folder
and then copies taht to the final location once the upload is complete.
It appears that there is a disk quota on that folder, which may be causing
your upload to fail.

I cannot think why just mdbs would be a problem.

HS
 
R

Robert Blackwell

I can zip up the dbase and upload it just fine. And yes, I can upload other
files of various extensions and of various file sizes (larger and smaller)
and they upload...hence zipping and uploading works fine.

I can't unzip on my server though, or atleast, I don't know how.
 
H

HSalim

Sorry, I dont know of any direct way to unzip remotely, although it
certainly seems possible.
If you are uploading to a webserver, you could create a web page with some
code to unzip it
That cant be too difficult.
HS
 
A

Albert D. Kallal

Hum, I would try compacting the file, and then perhaps making a copy.

Is there any other process on the computer that might have the file open?
 
R

Robert Blackwell

No, because when I try to upload, I'm uploading a copy that I got from the
computer hosting the file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top