Try doing the following in Access:
From a table of 400,000+ records, create 10 cursors which will result in 50-100 records each. Then LEFT JOIN those cursors to another cursor and throw the result set into an array. Then do all the above 10-20 times (using different keys), summing the result sets into the array. The create a cursor from the final array and bind it to a grid. This process must run in under 3 seconds.
After you have tried this in Access, let me know what happened - if you are still breathing.
>I am primarily creating database applications.
>
>I thought that VB would have close ties to Access and therefore be fairly strong in the database arena.
>
>What about Access itself? Why is Access not a viable alternative for serious database development?
- Jeff