Can you update a table/run queries without MS Access? (1 Viewer)

[coolhandphil]

Hi,

I'm using Microsoft Access 2010. I want to create a database that people without Microsoft Access can use. I'm not sure if this is possible...

If I create a database is it possible to use VBA in Excel to update a table in Access and then run/export a query? I know you can use Excel to communicate with MS Access but can you do it when you don't have MS Access installed on your computer?

I have daily sales data that I want someone without MS Access to be able to load into the database and then export a query from.

Any ideas?

Thanks,

Phil

 

[Galaxiom]

The easiest way is to use the free Access Runtime to run Access projects.

It is also possible to interact with databases via VBA in Excel or even with Word.

 

[coolhandphil]

Thanks, that looks exactly what I need. I'll give it a go.