Re: BD Constant Updates (Design)

Tech-Archive recommends: Speed Up your PC by fixing your registry

John, thanks for your advice.

Here's the thing: I forgot to mention that I already have the database split.
Data is on one DB and front-end on another. All the users access the front
end through the same DB, shared in a Network Drive. Thing is, I'm developing
as we speak and I have to ask people to exit the database all the time...
Is there a way to update forms, reports, modules, etc.. without asking users
to close the frontend?

Thanks

Antonio

John Vinson wrote:
>>Hi,
>>
>[quoted text clipped - 7 lines]
>>Thanks
>>Antonio
>
>Split the database.
>
>Use Tools... Database Utilities... Database Splitter Wizard to split
>the database into a "backend", containing the tables, and a Frontend
>containing all the user interface stuff. The backend should be on a
>shared drive; each user should have their own copy of the frontend,
>linked to it.
>
>You can then develop new features to your heart's content, and when
>you are ready, simply have the users delete their database and replace
>it with the latest version.
>
> John W. Vinson[MVP]


--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Split Database Security Problem
    ... Both frontend and backend ... > permissions, but as in all good stories there is a catch. ... The newAdmin for the 'object database' has the ...
    (comp.databases.ms-access)
  • RE: Form on front end loading slowly
    ... I gather the user has a frontend that uses a backend database on a server ... > have a database backend with a table that lists employees, ...
    (microsoft.public.access.formscoding)
  • Re: Split Database Security Problem
    ... Both frontend and backend ... > permissions, but as in all good stories there is a catch. ... The newAdmin for the 'object database' has the ...
    (comp.databases.ms-access)
  • Re: Multi users Logon Security questions
    ... > The next thing I need to do is split the database so others can work ... and navigate to the mdb - copy the mdb. ... You can use your desktop shortcut (which will open your frontend). ... Ctrl-O and open the backend mdb. ...
    (microsoft.public.access.security)
  • Split Database Security Problem
    ... I have managed to secure a split database. ... Both frontend and backend ... permissions, but as in all good stories there is a catch. ...
    (comp.databases.ms-access)