unable to create report with other user in db

[HG Lerdo]

Hi y'all!

We have the following setup here:

main server that holds the main Access 2000 database.
Clients from all over the intranet open can access that db.

Now for the problem:

User A has the db open and is not in design mode. Righ now
she isn't doing anything. Not changing data or what not.
She only has it open. Now user B opens the db in design
mode and wants to create a new report. But: she is not able
to do so!!

When I went through the archives of various forums and such
I found a lot about the wizard not being able to creat a
report, but nothing that comes close to my problem.

Does anyone have an idea what the cause of this is? Is it a
bug or a 'feature' or a setup prob on my part?

Thanks!!!

HG

 

[SA]

HG:

This is the default behavior for Access 2000 and later. If ANYONE other
than the current user has the db open, whether accessing or editing a record
or not, then objects like forms, reports and modules can not be saved to the
db. To design objects like that the user must open the db in exclusive mode
or be the only one with access to it (no pun intended).

The general way to work around this is to split the db into front end
(containing forms, reports, and code) and backend, which just contains the
data tables. Then each user has then has to have their own copy of the
front end installed on their machine locally. Assuming theirs a primary
developer of the db, when they make changes it would then be distributed to
the end user for update to their local machines.

In your situation if that step looks like it would take a while to
implement, then certainly you can have the local users create new dbs on
their machines, attach to the db on the lan and create their custom reports
in their local db in the near term.

 

[Hans-Georg Lerdo]

Hi Steve!

-----Original Message-----
This is the default behavior for Access 2000 and later.

I was afraid of that... :-(

Thanks for your fast reply!!!!

Later

Hans-Georg