Remote data access

[ayya]

I would like to develop a 3-tier database access system in VB 6; the backend would be Access.

Please let me know how to get started or suggest some good books.

Thanks,

Ayya

 

[Nagrom]

That's a pretty generic question. Basically you've just said "I want to write an application in VB, how do I do it?". This isn't meant to criticize you - it's just to let you know that it's pretty hard to answer. I CAN tell you that if you are starting from scratch, look into ADO and avoid data-bound controls. ADO (not to be confused with the ADO data control, which is a component you can add to your forms) has the best data access time, and is actually very versatile. I would think most VB6 books would get into it, but check them out first to make sure they don't just reference the ADO control - there's a world of difference, trust me. Also, before you decide on Access, really take a look at the scope of your data needs. Will it store a lot of data? Will it be accessed by multiple users at the same time? How much security do I need to be able to implement on the database? Access is really best for single user, single desktop applications that won't have large amounts of data (large, of course, being a subjective term, but you get the idea). Also, if you don't already have a good grasp of it, pick up a book on SQL. It is a necessity if you will be using any sort of database backend.