Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Advice Please

Advice Please

Advice Please

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.



RE: Advice Please

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

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


RE: Advice Please

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.

RE: Advice Please

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


RE: Advice Please

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close