Modify Queries (1 Viewer)

Hi,

In VB 2005, I know that we can connect MS Access database, can we use the codes to modify the queries in MS Access. Because, I use MS Access as backend, VB2005 as frontend, I need to use 15 queries from MS Access to do calculations, and also, the queries contents have been changed everytime depend on the user input different criteria of the VB2005 frontend window form. After that, export the data to Excel worksheets.
Can VB2005 easily do that?

For doing that, which Tools (MS Access, VB2005) is better to do this performance?

I would guess it would be quicker and easier in MS Access.

From a learning point of view, I would probably do it in VB2005. However I don't think I would link to the access data source, I think I would use MS SQL server 2005 as there is now a free copy available.

If I really had loads of time, I may even try and link VB2005 to SQLite.