VB vs. Access/VBA

[Darxion]

We are investigating the possible use of VB front end, "SQL" back end vs. Access and VBA (front/back or all-in-one). Does anyone have any information or know of any links to any information that would specifically address the pros and cons when determining which is better, faster, easier to use, etc.?

If you have personal experience with each, which is better and why/when?

Note: Currently using Access97. I would like comparisons of Access97 and/or Access2000 vs. VB6 and any type of "SQL" backend (MS Sequel Server preferred).

Thanks!