J
Jean-Francois Gauthier
Hi folks, I'm hoping someone here can help us get to where we want to go.
Our company is using an old database that is not very flexible in terms of
reporting. We are then finding to have to duplicate entries between the
system and excel in order to get the reports that our management want. The
system just doesn't have the tools to provide the kind of reporting we need.
So, my plan is to use access in order to import the data from the system
database and then make our own reports, either using excel or access. There
is a little bit of a hole in my plan. The extract from the system database
will include all data. We then need to create queries of the data to limit
the data viewable by a certain user.
My question here is therefore, how can I share this/these queries to various
users within their own cost centers, without letting them have access to the
other data?
we are usign Office 2003 and I believe the access database would sit on a
shared network drive.
Sincerely,
Jean-Francois
Our company is using an old database that is not very flexible in terms of
reporting. We are then finding to have to duplicate entries between the
system and excel in order to get the reports that our management want. The
system just doesn't have the tools to provide the kind of reporting we need.
So, my plan is to use access in order to import the data from the system
database and then make our own reports, either using excel or access. There
is a little bit of a hole in my plan. The extract from the system database
will include all data. We then need to create queries of the data to limit
the data viewable by a certain user.
My question here is therefore, how can I share this/these queries to various
users within their own cost centers, without letting them have access to the
other data?
we are usign Office 2003 and I believe the access database would sit on a
shared network drive.
Sincerely,
Jean-Francois