Advice Please

[JohnBoy2005]

I've been developing VB6/Access applications for years. Never had a problem.

I'm now starting to develop programs for my school that are starting to hold large amounts of data.

Do i need to start thinking about moving away from access and going to Microsoft SQL Server or MySQL. Also, is there any differences in access version 2003, 2007, 2010.

I also need some advice on whether I'm using the right data access components. I'm currently using DAO 3.6

Thanks in advance.

John

 

[HarleyQuinn]

If you are holding anywhere above 1 - 1.5gb of data then I'd say move to SQLServer and have a look into using ADO rather than DAO.

Hope this helps

Andy
---------------------------------
Zebracorn: 50% Zebra, 50% Unicorn = 100% Real.

http://lessthandot.com

 

[MajP]

2010 is an slight upgrade of 2007. However, 2007 provided some pretty big enhancements over 2003 and changed the actual database format. I would not develop in 2003 anymore unless there is a big cost to migrate. If there is a hint of doing sharepoint interaction you need to go at least 2007 and preferably 2010. Same thing if you are storing a lot of documents or images due to the far better ability to handle these.

If I was you I would really look at going vb.net with sql server (assuming you need to go away from ACCESS as Andy points out). VS is super nice to work with and makes this seemless. If you are not programming in vb.net, I would start. I am not anti VB6, but once you start programming in .net you will not want to go back. BTW you can do some pretty impressive things with SQL Server Express and VS at no cost since both are free.

DAO is optimized for JET so works real well with Acces and SQl Server. But for portability, flexibility I would go ADO.

 

[JohnBoy2005]

Thanks for the advice.

I have played around with VS and SQL Server, but for speed (at the moment), programming in VB6 is easier for me.

I have 2007 and 2010. If I still want to use Access, should i be using the accdb format or stick with mdb

Cheers

 

[MajP]

If you have both, I would go 2010 and the new database format. The .accdb format makes working with Sharepoint, images, and documents much easier. 2010 has data macros at the table level. It has bigger limits in certain areas. I have had no problems converting my .mdb files to .accdb files. I cannot see a reason to stay on the old format. As time goes by it will be harder and harder to maintain older formats.