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]

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).

 

[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.

 

[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

 

[Neil]

Thanks.

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

 

[Neil]

Thanks.

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.

 

[John Mishefske]

Thanks.

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).

 

[Master Programmer]

If you do an ODBC link to an access database over a network then the
client downloads the whole ****ing 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

 

[Albert D. Kallal]

If you do an ODBC link to an access database over a network then the
client downloads the whole ****ing 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.....

 

[Master Programmer]

You are incorrect.

The Grand Master

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

 

[ManningFan]

Me thinks the Grand Master got PWN3D. heh.