access and ecommerce (1 Viewer)

[mazer]

I have an access database on my site with two table, one for cards and the other for comics, each one has around 8000 entries, I know access really isn't the best database for this kind of job but at the moment it's all I can afford, my question is would I be better off using seperate database's, one for the cards and one for the comics? is it even possible to do this? or is there some other way I can prevent the slow down of database access when there is a lot of people accessing it at the same time?

 

[reclusivemonkey]

I know access really isn't the best database for this kind of job but at the moment it's all I can afford,

mySQL, which would be ideal for this purpose and is indeed used in thousands if not millions of shopping carts on the interent is free, both as in "speech" and "beer".

 

[nst]

I agree about MySql, it's "heavy artillery" and free.

Btw, did you check 'Compact on Close' at Options-Menu in Access? It might help.