Link to a Microsoft Access Database file

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

[hummingbird]

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]

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]

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

Cheers

-H

[tedster]

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]

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]

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

>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