Question Hosting an Access database on the web

[dave_mere]

Hi there,

I'm involved in a project that seeks to place a searchable database on the web. One senior member of the team suggested using Access as the database, which I assumed meant using Access as a back-end database and presenting the data vis some sort of web interface

What it appears he means is hosting the full database file on a webpage, and using the forms and search facilities of Access to provide the web pages's functionality. I don't have much experience in this area...in fact I've not actually seen it done before!

I've searched google for some examples, but come up blank. Could anyone offer any advice here? Can this actually be done? And if so, is it a good way to provide information online?

thanks in advance! dave

 

[Mr. B]

Speaking in the strictess sense, a standard Access database cannot be used as your Senior memeber has suggested. An Access datafile can be used as a storage container for a Web application when stored on a web server and linked to data aware pages. Previous versions of Access would create web pages but these were no longer considered to be an Access database. Again, they were data aware web pages linked to an access data file for storage container.

With that said, I would suggest that you do a Google search for "Access 2010". I am not a guru with Access 10 (yet) but as I understand it, this new version of Access will allow you to develop an Application and upload that applicaiton to a "SharePoint" server and still be able to manage, develope and use the applicaiton from Access.

Just my thoughts.

 

[Simon_MT]

There is nothing wrong with using Access databases on the web. I have never used ADP instead Classic ASP and ASP.Net.

This is an example of an Access driven web site:

http://www.trevorsutton.com/Originals_Groupings.aspx?Grouping=09TSP&OG=1

Simon

 

[NigelShaw]

There is nothing wrong with using Access databases on the web. I have never used ADP instead Classic ASP and ASP.Net.

This is an example of an Access driven web site:

http://www.trevorsutton.com/Originals_Groupings.aspx?Grouping=09TSP&OG=1

Simon

Is this an access driven website though or is it an asp website with an access data storage like many other asp websites?

ns

 

[Simon_MT]

Nigel,

Yes this an Acess driven ASP.net web site.

I did try Access 97 to html but was so underwhelmed I gave up.

Access 2000 and 2003, I never tried and when straight up to Access 2007 as I had satisfied my requirement with Classic ASP.

Simon