R
Rick in NS
I use an Access2002 form in pivot table view to create a work flow schedule.
The form is based on a simple select query on several tables. I have run the
query to confirm the underlying data is updateable.
A problem arises when I make an MDE file of the front-end and use the
schedule. The pivot table display permits users to use the drop downs and
check boxes to filter the data. However; when they exit the form and
re-enter the changes have not been saved.
I suspect the issue is the result of the necessity of saving with data
changes with the design of the pivot table form; which can't be done of
course, since the form is now in MDE format preventing design changes.
I would like to maintain the MDE format for the front end to prevent users
from viewing or changing form designs. I attempted placing the pivot table
form in another database in regular MDB format and creating a link without
success.
Anyone have any idea how I might resolve this issue?
The form is based on a simple select query on several tables. I have run the
query to confirm the underlying data is updateable.
A problem arises when I make an MDE file of the front-end and use the
schedule. The pivot table display permits users to use the drop downs and
check boxes to filter the data. However; when they exit the form and
re-enter the changes have not been saved.
I suspect the issue is the result of the necessity of saving with data
changes with the design of the pivot table form; which can't be done of
course, since the form is now in MDE format preventing design changes.
I would like to maintain the MDE format for the front end to prevent users
from viewing or changing form designs. I attempted placing the pivot table
form in another database in regular MDB format and creating a link without
success.
Anyone have any idea how I might resolve this issue?