Import data from ODBC

  • Thread starter Jean-Francois Gauthier
  • Start date
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
 
J

Jean-Francois Gauthier

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

bhicks11 via AccessMonster.com

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

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

Jean-Francois Gauthier said:
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top