Hyperlink to access Db

[desibaba]

Hi,
How can I create a link on a webpage for users to access the .mdb file? This is a very huge db, 40MB.

 

[jrbarnett]

You can use a standard http link if it is to come from a web page. For example:

<a href="[URL unfurl="true"]http://intranet/databases/mydatabase.mdb">My[/URL] Database</a>

or if you want it to point to a UNC pathname on a server:

<a href="\\server\sharename\databases\mydatabase.mdb">My Database</a>

Either way, the users will require MS Access or the Access Runtime installed on their PC.
The size of the file makes no difference as to how it will transfer over the network, just the time it will take to do that.

John

 

[MoLaker]

If you need to reduce network loading (although, 40 MB is not really that big for a network) or if you are making the database available over the Internet, you could zip the database (WinZip or something like it). You'll probably find it compresses as much as 75% or more. Make it a self-extracting executable and the user can uncompress it just by opening it. However, you must be aware of the individual user's browser and firewall settings. If over the Internet, the user's ISP might also get involved. It may have to be sent with the extension .exe changed to something else to fool the security measures, then the user could change the name back to reflect .exe.

But, John's statement is still correct that the user will need MS Access or run-time Access to open the database.