Problems running Access Databases! Locking/inability to control and maintain, and manage users, the growth?

Can I migrate to SQL 2000 or 2005?Problems running Access Databases! Locking/inability to control and maintain, and manage users, the growth?
You can migrate to SQL 2000 or 2005. You can even start using Oracle, as a vamp yahoo user told you to. But the question is, do you really need to migrate?





The locking/inability problems are solved in the Access Startup Menu, where you can set things like refresh time interval between a change in a record made by a user and the time need to the change to be seen across all access database users. Have you explored all the Access database features?





Speaking of my experience, I have a small Access database with about 20 000 entries, and no such problems are happening with me.Problems running Access Databases! Locking/inability to control and maintain, and manage users, the growth?
Note that you can migrate the *data* to SQL 2005, even the free version, and continue to use Access as a front end for queries and to develop applications.





If you are developing applications, you should look at the free version of Visual Basic 2005. It's an easy way to write simple database applications.
Dear, I'd suggest Oracle ;)
MS-SQL 2000/2005 is your easiest migration path.





for other options:


Oracle or Postgres would outperform and MS-SQL Solution





MySQL is ok for quick projects but won't scale as reaily as Oracle of PG
Obviously you should go to a more heavy duty database. You will get suggestions based on preferance but SQL 2005 or Oracle should resolve your problems as Access is not a good choice for multi-user scalable databases.