Which database would you recommend

Psionman · October 4th, 2004, 10:24 AM

Hi

We've written a neat application in VB6 using the native windows jet database (Microsoft DAO 3.51)

The application works fine, but we're being let down by the database - every day or so we have to repair the database. As this is a multiuser application (20 users) this is getting tedious and annoying the users

Does anyone have any recommendations for a more stable platform that doesn't cost the earth and doesn't take months to learn how to administer and will be reasonably compatible in terms of the code we've already written (just reads & writes to tables using indexes)?

Any advice gratefully received

Thanks
Psionman

sal · October 4th, 2004, 11:07 AM

Try looking into MSDE the free version of SQL Server, or better yet, try SQL Server 2005 Express. This have the full blown power of SQL Server, but MSDE has a limitation on concurrent connections. Overall, MSDE is a great DB engine and not too hard to learn. Do a search on MSDE on this site or Microsoft site.

I heard that Disney is using MSDE with a .net front end and something like 200 users. It is strong once you know the limitations. Just make sure to close the connections as soon as you get your data or do your data edit.

Sal