Development Suggestion

  • 14 years ago



    I need a suggestion. I’m developing a Video Rental Management System in VB2005 and I don’t know if a database in Access can hold the amount of data is going to be stored and manage. I have the application develop in SQL Server Express but this DBMS has a restriction for 4 GB of storage only, and my application stores pictures of the clients, which makes the database size grow fast.


    And I don’t want to include the charge of one SQL Server Standard or whatever version in my application price. I think I only have two options here: one is to use Access (but I don’t know if can hold) or two use MySQL Server.


    I have developed applications using Access before but not managing this amount of data. If somebody thinks Access is a good choice and can hold or MySQL is better, other one, any suggestion would be good.

  • 14 years ago
    I wouldn't use Access for a database that size.

Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“PHP is a minor evil perpetrated and created by incompetent amateurs, whereas Perl is a great and insidious evil perpetrated by skilled but perverted professionals.” - Jon Ribbens