Access Databases and Websites

[Esk247]

Is it possible to use a .mdb file (e.g. access database) and use it in the same way as say a MySql database on a server for a website?

[ken_uk]

It should be, there is a tutorial here (http://www.phpbuilder.com/columns/siddarth20000228.php3?page=1) about interfacing access 97 with a website. There are probably php classes around to do the same thing also.

However, if you can convert the data to mysql its probably better in the long run, as access was not really designed for web use, and will probably struggle with multiple users connecting at once if the site is a popular one.

I have not used access on the web, so dont know for certain how well it would hold up, gut feeling is it would be ok as long as the site is not heavily used.

[Esk247]

well its for submitting entries for the festival we're setting up this summer...deadline is 1st of March and im doing it for free at the moment..some kind helper built an access database for us to enter in the competition entries manually..but we want to tie this to the online entry form if possible.

i knew MySql would do it..but didn't want to have to set to work on that as i've hardly used it so far...i'll take a look at that link and see if i can create a bridge between access and the entry form.

[matt.chatterley]

Is it possible to use a .mdb file (e.g. access database) and use it in the same way as say a MySql database on a server for a website?

It's possible, though not ideal - saying that, should be fine as long as it isn't going to be a high volume site.

What platform does your hosting run - Windows or Linux (.NET or PHP)?

[Dwebs-Ltd]

well its for submitting entries for the festival we're setting up this summer...deadline is 1st of March and im doing it for free at the moment..some kind helper built an access database for us to enter in the competition entries manually..but we want to tie this to the online entry form if possible.

i knew MySql would do it..but didn't want to have to set to work on that as i've hardly used it so far...i'll take a look at that link and see if i can create a bridge between access and the entry form.

OK for low volume traffic not recommended for high volume.

ASP Classic / .Net easy as pie to connect to :)

[DambTech]

OK for low volume traffic not recommended for high volume.

ASP Classic / .Net easy as pie to connect to

We used Access for small sites that did not get alot of traffic but we found when we moved into .net something better was needed so we started using MSSQL.

cheers
Dave

[Dwebs-Ltd]

We used Access for small sites that did not get alot of traffic but we found when we moved into .net something better was needed so we started using MSSQL.

cheers
Dave

Even on small developments we use MSSQL cost wise its far easier to implement and maintain.

Plus we are now using MSSQL 2008 Web Edition which gives hosts most of the MSSQL STD features but at a tenth of the cost hence the prices we now charge are very low http://www.2008hosting.net/MicrosoftSQL/

[BusinessIdeas]

To answer the original question: Yes you can use access with cold fusion.

[ryanlundwebsolutions]

Yes you can, personally i wouldnt. As everyone has said MySQL does the job, isnt hard to create and maintain a database with and is free:)

Always used it, always will until something better comes my way.

[Esk247]

cheers people

MySql it shall be...we don't have any idea on traffic as the site isn't taking submissions yet..but we're getting 3000 hits per day and 80% are adding to their favourites so that will atleast double when people can actually enter the competition and we start advertising across several other platforms.