Solved

ftp Odbc connection

Posted on 2011-09-06
4
474 Views
Last Modified: 2012-08-13
hi,

how can i open connection to access db ( mdb ) using ftp ?
my ftp is : ftp://ftp.civileng.co.il/private/DB/mainDB.mdb.

thank you,
contel
0
Comment
Question by:contel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 36490182
I don't believe you can do that.  FTP is File Transfer Protocol and has it's own special methods and won't support the requirements of ODBC.  You can use that link to download the MDB to your computer but you can't open there.  FTP doesn't give you access to the driver that is needed on that computer, only to the file.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36490233
Perhaps you should rephrase this in terms of what you are trying to accomplish...?
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
ID: 36490372
If you are wanting to download the file it is possible.
FTP Client functions

If you are trying to open a recordset or link to a table it is not possible.  JET is a LAN database engine. It will not work over http, ftp, etc.    I don't know of any database that will work via FTP protocol/

See:  Running an Access database over the internet

0
 
LVL 16

Expert Comment

by:AlexPace
ID: 36491861
You could roll your own using a scriptable FTP server, but it would be ugly.

On the client side you would make a little file named <filename>.sql where the <filename> part is a unique string.  The file would contain an SQL statement.  Then you would connect to the FTP site, upload the file, and start requesting a directory listing every 5 seconds or so.  The scriptable FTP server would, whenever a *.sql is received, extract the SQL statement, execute it against your Access database using ADO, persist the resulting recordset to a file, rename the persistedfile as <filename> and then delete or archive the .sql file.  At this point the FTP client will notice the new file in the directory listing and download it.  Your client will inflate the recordset back into an object for use in your code.
0

Featured Post

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question