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

coolhandphil

New member
Local time
Today, 11:11
Joined
Sep 5, 2014
Messages
5
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

Super Moderator
Staff member
Local time
Today, 21:11
Joined
Jan 20, 2009
Messages
11,866
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

New member
Local time
Today, 11:11
Joined
Sep 5, 2014
Messages
5
Thanks, that looks exactly what I need. I'll give it a go.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom