Referencing reports from Microsoft Access

[littlegreenmen]

I have several stores that I have generated different graph reports for. I am
trying to set it up so that when the general manager from a store logs in he
can select to view reports only pertaining to his store. For example, he can
select to view the 'total store sales'report, or the 'total sales of widget x'
report. All of these reports were created individually in Access. tHow do I
go about referencing these reports from access in general? also, how do i set
it up to where the gm gets to see only the reports that go with his store. I
have a table set it with the different users and each gm has a unique storeID
number. Any help with my dilema would be much appreciated.

[jorgepino]

First of all,
I would recommend moving away from access, and move to MSsql or to MYsql,
Access was not made for web access and some problem may occur, like data
corruption or data lost

to get access to your report you will have to create a web application ro
replicate your reports
no easy way,