L
Lyndon
Hi all,
This may seem like a silly question given Access is a database
management tool, but I am working on a project to develop a change
management tool that will allow users to request changes to certain
data values within tables in a production environment database. The
change management tool will have a local copy of the database that will
allow the administrators to make changes to the data in the local
database and then generate an output file that contains the necessary
SQL update queries to update the production database after the changes
have been implemented (similar in concept I suppose to CVS where the
local copy is used to update the baselined version). Why this
particular architecture was adopted is not for me to comment on, I am
just building the system.
The administrators of the system have little to no database knowledge
so the requirement is to build a front end system using Access forms
that allows the local Access database to be manipulated as described
above. Typical operations would be to update a row of data, insert a
new row or create a new table. What I am basically required to do is
build a dumbed down version of Access using Access forms and VBA that
facilitates and validates these basic commands. I am wondering if
anyone knows of any sample projects or APIs that would assist in this
regard... I would like something that coupld possibly generate a
graphical representation of an Access database and display that in an
Object or Image frame and then allow tables to be opened by double
clicking or something. Any help would be greatly appreciated...
Many thanks,
Lyndon.
This may seem like a silly question given Access is a database
management tool, but I am working on a project to develop a change
management tool that will allow users to request changes to certain
data values within tables in a production environment database. The
change management tool will have a local copy of the database that will
allow the administrators to make changes to the data in the local
database and then generate an output file that contains the necessary
SQL update queries to update the production database after the changes
have been implemented (similar in concept I suppose to CVS where the
local copy is used to update the baselined version). Why this
particular architecture was adopted is not for me to comment on, I am
just building the system.
The administrators of the system have little to no database knowledge
so the requirement is to build a front end system using Access forms
that allows the local Access database to be manipulated as described
above. Typical operations would be to update a row of data, insert a
new row or create a new table. What I am basically required to do is
build a dumbed down version of Access using Access forms and VBA that
facilitates and validates these basic commands. I am wondering if
anyone knows of any sample projects or APIs that would assist in this
regard... I would like something that coupld possibly generate a
graphical representation of an Access database and display that in an
Object or Image frame and then allow tables to be opened by double
clicking or something. Any help would be greatly appreciated...
Many thanks,
Lyndon.