Adding fields to report: Can't save in open shared mode

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Using Access 2002, my database is for single users, on their desktop
and is split (FE/BE). I allow users to add fields to tblCustom via a
form and VBA. It works great. I use a query to combine the data from
tblCustom to related data in other tables. To display the query in a
report, I use VBA to open the report, delete the old custom fields, add
the refreshed list of custom fields and save the report.
To open and close the report I use:
DoCmd.OpenReport stgReportName, acViewDesign, , , acHidden
DoCmd.Close acReport, stgReportName, acSaveYes

The process works fine, as long as I am Open Exclusive on the front
end. However, my users can't use open exclusive when the use the db
because of other code which uses currentdb and would cause an error.
Also I can't expect a user to close and reopen the db everytime they
wanted to change a custom field.

My question: how do I in a shared mode save changes to the report? Is
there a better way to dynamically update an existing report to reflect
new fields in a table?

TIA. I learn alot from this boards.

Mark
 
Mark:

By design, Access objects (forms / reports / VBA etc.) can't be changed or
saved when in non-exclusive mode (as you've found). There's no setting etc.
that would allow this to change. The preferred way to manage this is to
give every user their own copy of the front end, stored locally, which is
opened by them in exclusive mode when they run the application. This allows
them to modify things locally. The backend data is then the only shared
mode access portion of the app.
 
Using the lowest common denominator of my users, having them open in
exclusive is asking alot, but it seems like there isn't any other way.

Thanks
 
Back
Top