Making Access database available in web. How to do?

[Television]

Greetings!

I am doing a database for our Pompeii Project, which is ending soon(ish), using Access 2010. Our database contain info of our excavations in Pompeii and we would like to share this info in internet so that other researchers and people who are interested in our data could use it to make they own queries etc. After Project's closure database will not be modified anymore, but some light maintenance will be done infrequently. We want interested people to make searches, but obviously not to make any changes.

We will get server space from either our University or from some similar instance, but before we can start to do some serious negotiations we need to know what we actually need. We don't have much money (serious problem in archaeology, which tends to turn money into knowledge instead the other way around ) so commercial solutions are probably out of our range. Data will be relevant for a quite long time so it would need to be available online for a long time too.

What kind of options are there? Any advice is welcomed!
Thank you!

Television

 

[apr pillai]

Let this link be the starting point for you to get some idea as how to go about putting your Access Database on Internet: Using MS-Access on Internet.

I think, Wordpress.org Software (Blog Platform) is a better option for publishing your data. You need to buy some Webhosting plan and install Wordpress software, before you are able to start publishing.

 

[Pat Hartman]

Since your budget is limited and you are asking only to make data available rather than to actually create a web application to do analysis, the easiest, cheapest solution is to simply zip the Jet/ACE database containing the tables and make it available for download. The user can then unzip and work with the data in Access or load it into SQL Server or Excel if he prefers.

I would not even consider making a web app with A2010. The technology in A2013 is completely different and not compatable so any web app created with A2010 is already deprecated.

A middle ground, if you have SharePoint available, is to transfer each table to sharepoint as a list. I don't really like this option but it does give people limited viewing capability essentially for free but they won't be able to work with it effectively as Sharepoint Lists, they would need to download back to Jet/ACE tables to get it back to being a relational database.

 

[Simon_MT]

Do the contents of the database need to be available to the search engines or due to the specialised nature of the information it can only be interpreted by other archaeologists?

How will others know about your project?

Simon

 

[Television]

Do the contents of the database need to be available to the search engines or due to the specialised nature of the information it can only be interpreted by other archaeologists?

How will others know about your project?

Simon

Most of the people who are interested in our project will probably be researchers, but there are number of laymen who are interested in this kind of material, so visibility to search engines would be a good thing. Our project is well know in certain circles so I believe that our publication will be noted widely and mentioned in ex. several blogs and journals (through grapevine one might say).
Thank you for your interest!
Television

 

[Simon_MT]

Then you should really produce readable web pages.

Simon