Access Database through ftp...

Our companys website maintains an Access database which contains customer information and shipping information.  Our only access to this database is through ftp.  I need to update the shipping information in the database but I don't know how to connect to it.  From my machine at work I would first need to go through our firewall and then login to the ftp site.  How should I go about updating this database without pulling it down first, then updating it, and uploading it to its original place?  Maybe I didn't ask right...I just don't know where to go from here...  I can give any details that maybe helpful to point me in the right direction.
Kx9029Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wesleystewartCommented:
Working with your internet guys, can you jsut get access to the directory on the server where the .mdb file resides, and then directly manipulate the records?  With optimistic locking Access should lock down all the records while you're updating one or two customers at a time or something like that.

Somewhere that .mdb file resides on a server.  That would be my first target.  You could link directly to the table with the info you need to update and work on it as and when you wish.

Wes
0
Kx9029Author Commented:
Right, the .mdb file does reside on the server but my problem is that I only have ftp access to that server.  Is there an odbc driver that can ftp into a site and then connect to the database or is there another route I should take from there?  The ftp access I have to the site is directly to the database directory.
0
mcriderCommented:
FTP stand for File Transfer Protocol.

Unfortunately, if FTP is your only access, you can't use an odbc driver to update it.... You will have to FTP the file to your system, update the mdb file and FTP it back to the server...


Cheers!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kx9029Author Commented:
I feel like saying duh! to myself.  I do deserve one, anyhow thanks for the input.  Thats what I was afraid of from the begining....thanks for your time.
0
mcriderCommented:
I say DUH! to myself all the time... No big deal ;-)  Thanks for the points! Glad I could help!


Cheers!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.