MDB on Web?

[Neil]

Can an MDB on a local machine be linked to tables in a back end MDB that's
on an FTP site?

[Rick Brandt]

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

[Douglas J. Steele]

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?

[aaron.kempf]

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

[Neil]

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

[Neil]

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?

[John Mishefske]

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
'---------------

[Master Programmer]

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?

[Albert D. Kallal]

"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

[Master Programmer]

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

[ManningFan]

Me thinks the Grand Master got PWN3D. heh.

Master Programmer wrote:

You are incorrect.

The Grand Master