Welcome to WebmasterWorld Guest from 54.144.79.200

Forum Moderators: phranque

Message Too Old, No Replies

Link to a Microsoft Access Database file

How to create a link from a web page to MS Access file

     

hummingbird

6:22 pm on May 25, 2001 (gmt 0)

5+ Year Member



The company I am working for has an Intranet and would like to have a link in a web page to a Microsoft Access Database file. We have an Apache server.

I tried to placed the db in a folder on the server and when I click on the link in the web page the Access file does not open.

Any specific configuration that I need to do. (For a Word document though is works perfectly.)

Looking forward to read your suggestions

--H

sugarkane

11:15 am on May 26, 2001 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Depending on what version of apache you're using, there should be a file in the configuration directory called 'apache-mime.types', 'mime-types.conf' or something similar.

Try adding the line:
application/msaccess ext

Where 'ext' is the file extension that Access uses (I can't remember off hand...). You may need to restart apache before the change takes effect.

This should work, but I've never tried it.

hummingbird

12:33 am on May 29, 2001 (gmt 0)

5+ Year Member



Thank you Sugarkane, it worked. (Access file extension is .mdb)

Cheers

-H

tedster

3:39 am on May 29, 2001 (gmt 0)

WebmasterWorld Senior Member tedster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



I have a related question. A client of mine paid a developer for an Access database. The developer (who now is impossible to reach) said in his written instructions that the database MUST be served on NT.

Can that be true?

Woz

3:47 am on May 29, 2001 (gmt 0)

WebmasterWorld Senior Member woz is a WebmasterWorld Top Contributor of All Time 10+ Year Member



if you are going to serve dynamic pages from the Access database then Yes, it must be served on NT. IIS has the functions built in to run access just the same as running it on PC. I believe from Toolman that ASP will run on unix through Chillisoft, but as far as I am aware Access cannot.

In the case above, the access database is residing on the unix server, but when "clicked on", I believe the database would be loaded in the client machine, ie., Windows.

Onya
Woz

Marcia

4:22 am on May 29, 2001 (gmt 0)

WebmasterWorld Senior Member marcia is a WebmasterWorld Top Contributor of All Time 10+ Year Member



>when "clicked on", I believe the database would be loaded in the client machine, ie., Windows.

Couldn't this potentially represent some sort of security problem?

Woz

4:37 am on May 29, 2001 (gmt 0)

WebmasterWorld Senior Member woz is a WebmasterWorld Top Contributor of All Time 10+ Year Member



>Couldn't this potentially represent some sort of security problem?

on an open internet site yes. However, in the original post hummingbird is talking about an Intranet.

Onya
Woz

 

Featured Threads

Hot Threads This Week

Hot Threads This Month