Re: Multiple users on an Access database

Tech-Archive recommends: Fix windows errors by optimizing your registry

I've used Access databases in the past with over 10 users and this was quite
easy to achieve. i.e. Once the report was not opened by one of the other
users your could modify it and save it, it is not possible in later version
of access?

Its quite essential in my application that I'm able to modify reports when
other users are in my database, I'd be grateful of additional feed back.

Thanks,

Alan.

"Keith Wilby" wrote:

"AlanK" <AlanK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:34D8B280-A852-4991-B3BA-E71B195ED5F5@xxxxxxxxxxxxxxxx

Hi Tom,

I've split the database however I'm still encountering problems.

There are two users.

If one user has the database open (with no tables / queries / reports or
forms open) and the other user enters the database and tries to modify the
design of a Report or Form the following message appears " Microsoft
Office
Access can't save design changes or save to a new database object because
another user has the file open. To save your design changes or save to a
new
object, you must have exclusive access to the file". The database is in
shared mode. Any ideas?


Hi Alan,

No offence but I think you may fundamentally misunderstand the concept of a
multi-user database. In my experience you can *never* have more than one
concurrent developer on the same front end. You should also never do
development work on a production system, rather you should have a
development copy to work on which you would then deploy to your users (one
copy each) for data manipulation and report generation. That is where the
benefit of splitting comes.

Regards,
Keith.
www.keithwilby.com


.

Relevant Pages

  • Re: Multiple users on an Access database
    ... I think version 97 was the last one that allowed you to modify objects while someone else was using the mdb - not any more. ... I've split the database however I'm still encountering problems. ... design of a Report or Form the following message appears " Microsoft ... Access can't save design changes or save to a new database object because ...
    (microsoft.public.access.security)
  • RE: updated numbers in report
    ... for making an input to the database. ... textbox will be located alongside with the combobox where the belonging ... belonging query for the report. ... ElapsedTime([Date First Time Onboard], ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Creating a report entirely through code
    ... In my case this is a very simple database, ... >> thus greatly increase the probability of corruption. ... >> button doesn't gray out after a compile, a control starts to ... >>>report and not a form where they have to enter data in. ...
    (microsoft.public.access.formscoding)
  • Re: Creating Access DB
    ... database and in the SQL database that your report needs. ... click the query tab. ...
    (microsoft.public.excel.programming)
  • Re: Exclusive access to the database
    ... Do you mean that two managers can't modify the same report at the same time ... "Rick B" wrote: ... You should split your database into Front-End and BAck-End. ...
    (microsoft.public.access.security)