Good DB for VB app w/ website 1

[JFRobishow]

Hi everyone,

I'm currently developping an software for a small company. I've used an backend MS Access database to start, but I'm wondering if I've made the right choice.

The company will be using that database to maintain an online store (inventory and cliendID, stuff like that will be stored in it)

The site will be more than likely small, I would say close to 10 concurrents user as a BIG maximum. Is Access going to cause me trouble? Should I consider moving to MySQL for the website?

I'm a novice, so I don't really know how to work with MySQL (read never done it) specially not implement it in the application...as I'm guessing I could figure out the website part.

Tips and suggestion are welcome.

 

[johnwm]

You need first to check out what your website hosting package will support. If it will support Access then you should be OK as long as you make sure that you open connections and recordsets only when you need them and close them as soon as you've finished with them.

If there is any prospect of the site expanding, then look seriously at using a host that can supply either MSSQL or mySQL

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[JFRobishow]

Thanks johnwm for yet again an informative reply.

I'll keep access as a backend for the application and if they really want to have MySQL for the website after I bring my point I'll suggest that they use a software that can make convertion from Access to MySQL.

Don't think I'll run into problems that way.