Hi,

I've a wee macro running nicely in Access that I'd like to redo in VB6 to make a standalone .exe

However, it uses tables and queries to populate controls and to search and display the end result.

Can I use Access tables/queries somehow in VB6? If not, what's the best equivalent?

Thanks for any assistance.

Hi,

I've a wee macro running nicely in Access that I'd like to redo in VB6 to make a standalone .exe

However, it uses tables and queries to populate controls and to search and display the end result.

Can I use Access tables/queries somehow in VB6? If not, what's the best equivalent?

Thanks for any assistance.

Yes it is possible to use an Access database from VB6.

I did a googled this: VB6 read Access database (click Here)
(http://www.google.com/#hl=en&source=hp&q=VB6+read+Access+database&btnG=Google+Search&aq=f&aqi=&aql=&oq=VB6+read+Access+database&gs_rfai=C8SFuvngpTO2FHIfAzQT6vsS0CgAAAKoEBU_Q177N&fp=e0fa4b5da4f245a4)

Here is one result that might be helpful: Here (http://www.vb6.us/guides/vb6-database-guide)