Hello,
I have a HUGE access database with 20 or so queries. After the queries run, it exports to excel then I send it out to everyone myself.
Well now we want people to be able to have access to the database, update the source data and view the queries.
Is there a way through SQL, OLAP, Visual Studio or something else that can allow me to have people access a form from a shared intra-network to query my queries?
The point is, I'm trying to figure out how to create a user friendly, multi-user database.
Does anyone here have any experience and can share some stories or suggestions?