Creating reports at runtime on multiuser database

[Mike Cooper]

Hi everyone,

I have created a form in an access database called "Report Creator"
which creates a SQL statement based on options that a user selects and
then opens a (predefined) report with that SQL statement as the
report's recordsource. It works great. The problem is that since a
property of the report is being altered,the user requires exclusive
access to the database to do it. At any given time 3-5 people are in
this database accessing info or updating it, and my boss is getting
tired of asking everyone to get out while she runs a report.

Does anyone know a way around this limitation? Any suggestions would
be appreciated.

[MA]

"Mike Cooper" <bi*****@yahoo.com> ha scritto nel messaggio
news:df**************************@posting.google.c om...

Hi everyone,

I have created a form in an access database called "Report Creator"
which creates a SQL statement based on options that a user selects and
then opens a (predefined) report with that SQL statement as the
report's recordsource. It works great. The problem is that since a
property of the report is being altered,the user requires exclusive
access to the database to do it. At any given time 3-5 people are in
this database accessing info or updating it, and my boss is getting
tired of asking everyone to get out while she runs a report.

Does anyone know a way around this limitation? Any suggestions would
be appreciated.

Why do you work on the same FE together?
Give them a FE.
Or if you cant, create a file in local host and after export the report
formatted, killing the old one.
MAssimiliano