A
Arvi Laanemets
Hi
At last I found out how to link the external dbf-files (used by third-party
program at same time) to access database. But now I have some questions, and
maybe I can find some good advice here - I never have enjoyd inventing the
bicycle myself.
1. When distributing the database, is there some way to avoid the manual
creating of ODBC Data Sources (System DSN) on every users computer?
2. Is there a way the query would return only preselected columns of data -
p.e. one table contains nearly 100 columns (half of them empty), but I do
need only 5-6 of them. The rest of them is abundant for my purpouses, and
they can contain some personal data for limited access only.
The situation:
We have a third-party program having modules for personal managment and
salary accounting. The data (dbf-files) are stored on network resource with
limited access (user-level sharing). Now I'm designing some access database,
which needs some data (employees codes, names, codes for departments they
belong in, their appointment codes, lists of departments and appoitments,
etc.) from these tables. And, as mostly the users working with my
application don't have the access to original dbf-tables, I want to control
what kind of info is available to them.
3. And so another problem - as rule the users don't have the access to
network source with dbf-data. An unfamilar situation for me. Probably I have
to create a separate Access database with links only, store it on some
accessible network resource, and link the queries there to my database. And
someone with access to protected network resource has to refresh the data
there at some shedule. Or is there some better way? Any ideas?
Arvi Laanemets
At last I found out how to link the external dbf-files (used by third-party
program at same time) to access database. But now I have some questions, and
maybe I can find some good advice here - I never have enjoyd inventing the
bicycle myself.
1. When distributing the database, is there some way to avoid the manual
creating of ODBC Data Sources (System DSN) on every users computer?
2. Is there a way the query would return only preselected columns of data -
p.e. one table contains nearly 100 columns (half of them empty), but I do
need only 5-6 of them. The rest of them is abundant for my purpouses, and
they can contain some personal data for limited access only.
The situation:
We have a third-party program having modules for personal managment and
salary accounting. The data (dbf-files) are stored on network resource with
limited access (user-level sharing). Now I'm designing some access database,
which needs some data (employees codes, names, codes for departments they
belong in, their appointment codes, lists of departments and appoitments,
etc.) from these tables. And, as mostly the users working with my
application don't have the access to original dbf-tables, I want to control
what kind of info is available to them.
3. And so another problem - as rule the users don't have the access to
network source with dbf-data. An unfamilar situation for me. Probably I have
to create a separate Access database with links only, store it on some
accessible network resource, and link the queries there to my database. And
someone with access to protected network resource has to refresh the data
there at some shedule. Or is there some better way? Any ideas?
Arvi Laanemets