By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

MDB on Web?

P: n/a
Can an MDB on a local machine be linked to tables in a back end MDB that's
on an FTP site?
Nov 22 '06 #1
Share this Question
Share on Google+
10 Replies


P: n/a
Neil wrote:
Can an MDB on a local machine be linked to tables in a back end MDB
that's on an FTP site?
No. Access cannot link over HTTP or FTP. You need actual network access (the
ability to open the file).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Nov 22 '06 #2

P: n/a
No. Access doesn't recognize the FTP protocol (nor HTTP, for that matter.)

You must be able to map to the share on the server.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Neil" <no****@nospam.netwrote in message
news:jq*****************@newsread2.news.pas.earthl ink.net...
Can an MDB on a local machine be linked to tables in a back end MDB that's
on an FTP site?

Nov 22 '06 #3

P: n/a
MDB doesn't work across ANY network.. i mean.. vpn, wireless,
multi-user simple LAN..

MDB is a piece of shit lose the training wheels

-Aaron
Rick Brandt wrote:
Neil wrote:
Can an MDB on a local machine be linked to tables in a back end MDB
that's on an FTP site?

No. Access cannot link over HTTP or FTP. You need actual network access (the
ability to open the file).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Nov 22 '06 #4

P: n/a
Thanks.

"Rick Brandt" <ri*********@hotmail.comwrote in message
news:0w******************@newssvr13.news.prodigy.c om...
Neil wrote:
>Can an MDB on a local machine be linked to tables in a back end MDB
that's on an FTP site?

No. Access cannot link over HTTP or FTP. You need actual network access
(the ability to open the file).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Nov 22 '06 #5

P: n/a
Thanks.

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.comwrote in message
news:e0**************@TK2MSFTNGP04.phx.gbl...
No. Access doesn't recognize the FTP protocol (nor HTTP, for that matter.)

You must be able to map to the share on the server.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Neil" <no****@nospam.netwrote in message
news:jq*****************@newsread2.news.pas.earthl ink.net...
>Can an MDB on a local machine be linked to tables in a back end MDB
that's on an FTP site?


Nov 22 '06 #6

P: n/a
Neil wrote:
Thanks.

"Rick Brandt" <ri*********@hotmail.comwrote in message
news:0w******************@newssvr13.news.prodigy.c om...
>>Neil wrote:
>>>Can an MDB on a local machine be linked to tables in a back end MDB
that's on an FTP site?

No. Access cannot link over HTTP or FTP. You need actual network access
(the ability to open the file).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Little clarification here. Access works on a network.

The protocol it uses is SMB/CIFS which is more commonly known as "shares" in Microsoft-speak.

In a single network of Microsoft-loaded PCs you can share a folder on one PC with other
PCs. The network protocol to do this is SMB/CIFS.

Linux (and some unix) OS's have products that support this protocol - most notably SAMBA.
http://us3.samba.org/samba/

This is not a routable protocol so it it limited to the network (or subnet) that the PCs
share. That is the primary reason it can't be used in the environment you described.

FTP and HTTP are routeable protocols and meant for internetworks. Unfortunately Jet
(Access) doesn't directly support them.

However, you generally don't make your database available this way. Instead you run some
type of web application server that handles HTTP (or FTP) requests from clients and does
all the database interaction on the server side (unseen by the client).

--
'---------------
'John Mishefske
'---------------
Nov 23 '06 #7

P: n/a
If you do an ODBC link to an access database over a network then the
client downloads the whole fucking file before opening it. So it is
useless for that.

Aaron is correct, Access is for babies. Dump that shit and learn to do
it the proper way - SQL Server. At the moment you are just making a
fool of yourself.

The Grand Master
Knowledge is Everything
Neil wrote:
Thanks.

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.comwrote in message
news:e0**************@TK2MSFTNGP04.phx.gbl...
No. Access doesn't recognize the FTP protocol (nor HTTP, for that matter.)

You must be able to map to the share on the server.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Neil" <no****@nospam.netwrote in message
news:jq*****************@newsread2.news.pas.earthl ink.net...
Can an MDB on a local machine be linked to tables in a back end MDB
that's on an FTP site?
Nov 23 '06 #8

P: n/a
"Master Programmer" <ma***************@outgun.comwrote in message
news:11*********************@m7g2000cwm.googlegrou ps.com...
If you do an ODBC link to an access database over a network then the
client downloads the whole fucking file before opening it. So it is
useless for that.
first, you are 100% wrong. When you use a file share on a network (non
odbc), and request one record out of a table of 500,000 records, THEN ONLY
ONE record is loaded from the mdb file.

In the case of ODBC, the SAME thing occurs, and if you request ONE record,
then ONLY THE ONE RECORD IS TRANSFERRED.

So, you are 100% WRONG here.

I explain this record loading process here in detail, and also explain why a
mdb file can corrupt when the connect is poor.

Title:
Using a wan with ms-access? How fast, how far?
By Albert D. Kallal
Saturday, August 09, 2003
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

So, you are just wrong.....

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com

Nov 24 '06 #9

P: n/a
You are incorrect.

The Grand Master

Albert D. Kallal wrote:
"Master Programmer" <ma***************@outgun.comwrote in message
news:11*********************@m7g2000cwm.googlegrou ps.com...
If you do an ODBC link to an access database over a network then the
client downloads the whole fucking file before opening it. So it is
useless for that.

first, you are 100% wrong. When you use a file share on a network (non
odbc), and request one record out of a table of 500,000 records, THEN ONLY
ONE record is loaded from the mdb file.

In the case of ODBC, the SAME thing occurs, and if you request ONE record,
then ONLY THE ONE RECORD IS TRANSFERRED.

So, you are 100% WRONG here.

I explain this record loading process here in detail, and also explain why a
mdb file can corrupt when the connect is poor.

Title:
Using a wan with ms-access? How fast, how far?
By Albert D. Kallal
Saturday, August 09, 2003
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

So, you are just wrong.....

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Nov 27 '06 #10

P: n/a
Me thinks the Grand Master got PWN3D. heh.

Master Programmer wrote:
You are incorrect.

The Grand Master
Nov 27 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.