Import data from ODBC

[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

 

[bhicks11 via AccessMonster.com]

You could have a process that runs Make Table Queries that pulls the
appropriate data into a table for each user or you could have a query that
filters the data based on the user id (use Dev Ashish's fosUserName funtions
http://www.mvps.org/access/api/api0008.htm). You would need to add user and
group security. I'm thinking out loud.

Bonnie
http://www.dataplus-svc.com

 

[Jean-Francois Gauthier]

Thank you Bonnie for your reply. I will continue to ponder this and of course
keep in mind your kind advice.

 

[bhicks11 via AccessMonster.com]

Hope it works out. You can always post back if you have problems.

Bonnie
http://www.dataplus-svc.com

Thank you Bonnie for your reply. I will continue to ponder this and of course
keep in mind your kind advice.

You could have a process that runs Make Table Queries that pulls the
appropriate data into a table for each user or you could have a query that

[quoted text clipped - 28 lines]