VB and Access

[moose]

Here lately most of my programs I have written with a VB front end and Access back end. I'm using Access to develop the queries and create the reports from those queries. Is there a downside to doing this? Should everything be done in VB and just use Access for storage of the data? Or does it really matter?

[parksie]

The best way is the way that works the best.

...or...

If it ain't broke, don't fix it.

I think these quotes are suitable in this situation. If your program works fine as it is, then leave it like that. Since you're doing reports, you'd have to have Access. Although, it is better to keep as much as possible in VB, for example, use SQL rather than a QueryDef for queries.

[James Stanich]

I create Vb programs which use Access as the main means o storage. I appreciate Access since you can use automation with access to export the data to text files, spreadsheets, and different formats of databases(dbase IV has been extremely useful in the current app I am creating). Plus, with Access, you can set up pre-determined queries, and just use that as your datasource. Since Access is so flexible with its data storage capabilities, and I found it a lot easier to create forms in VB, I would suggest just using Access for the storage.

Just my $.02 worth.

Good luck.